Airline Finance fleets, routes for Brazil and the US, Brazilian sale prices live · assets and live layers next
A living map of the world's aircraft: who owns and operates them, which routes they fly and how full those routes are, what the planes are worth and when their leases expire. Everything comes from public sources and every number links back to where it came from.
What the page shows, and what is still to come
| Layer | What you see | Status | Sources |
|---|---|---|---|
| Fleet | Aircraft registered per country, drawn as filled borders with the number on each; states and provinces, then cities of the registered owner, as you zoom in. Eight aircraft segments you can switch on and off (drones, helicopters, fixed-wing by seats up to 251+), with presets for regional and long-haul. Type, age and owner mix; top operators and owners; owner versus operator versus lessor. | Live | 16 national civil-aircraft registers downloaded in full (FAA, Transport Canada, ANAC Brazil, CASA, CAA NZ, DGAC France, IAA and more) plus the OpenSky aircraft database; Natural Earth borders; US Census and GeoNames postcode points |
| Routes | Airport pairs drawn as arcs: width is seats offered, colour is load factor; monthly history per route, carriers, aircraft types and class. | Live for Brazil and the United States | US BTS T-100, ANAC Brazil statistics. Next: Eurostat avia_par, Australian BITRE |
| Values | Declared sale prices in Brazil by type and age at sale. | Live | ANAC Registro Aeronáutico Brasileiro |
| Assets | Per operator: fleet age, owned versus leased, appraised values and loan amounts from aircraft-backed bond filings, lease and debt maturities. | Planned | SEC EDGAR (EETC prospectuses since 2001), Cayman and Bermuda exchange listings, Ex-Im Bank authorizations |
| Live | Aircraft in the air right now; click one to jump to its registration, owner and usual routes. | Planned | OpenSky Network real-time API |
| Opportunities | Routes that stay above 85% full with one or two carriers, flown by ageing aircraft, where leases are about to expire. Each score opens its sources. | Planned | Derived from the layers above |
How aircraft types are classified
Aircraft types are fixed, so the page keeps its own aircraft-type reference library keyed by ICAO type designator (ICAO Doc 8643). Each register's spelling of a model is matched to a designator, mostly by joining the aircraft's 24-bit address to the OpenSky database. Actual cabin seats per airline and type come from US T-100 (seats divided by departures). Manufacturer figures for range, entry year and generation are not filled in yet; nothing is entered without a source.
Honest limits
- Below country level the map shows the registered owner's address, not where the aircraft is based. Trustees and lessors concentrate aircraft at their own addresses.
- Route-level load factors are public only for the United States (including international segments), the EU, Brazil and Australia; China, the Middle East and Southeast Asia stay blank until paid flight data is added.
- Aircraft class on Brazilian routes is inferred from each carrier's registered fleet, because ANAC route statistics carry no aircraft type.
- Per-aircraft lease rates are not published anywhere. The asset layer will use proxies and say so.
- OpenSky data is crowd-sourced and incomplete; seat counts are unknown for about 7% of aircraft and these are kept as their own segment.
Build order
- Fleet layer and the change feed. Done.
- Route layer, Brazil first, then the United States. Done; a time slider is still to come.
- Live layer via OpenSky.
- Asset layer and the opportunity board.
Sibling pages: Airline operations (open analyst roles at aviation employers) · CMBS Property Atlas (the same method applied to commercial real estate).
航空金融 机队、巴西与美国航线、巴西成交价已上线 · 资产层与实时层在后
一张活的世界飞机地图：谁拥有、谁运营，飞哪些航线、航线有多满，飞机值多少钱、租约何时到期。全部来自公开来源，每个数字都能回到出处。
页面现在有什么、接下来做什么
| 图层 | 能看到什么 | 状态 | 来源 |
|---|---|---|---|
| 机队 | 各国在册飞机，按国家边界填色并标数字；放大后依次是州/省、登记所有者所在城市。八个机型分段可开可关（无人机、直升机、固定翼按座位直到 251 座以上），带支线和长途预设。机型、机龄、所有者构成；最大运营人和所有者；所有者、运营人、出租人的关系。 | 已上线 | 16 个整库下载的国家民航登记库（FAA、加拿大运输部、巴西 ANAC、CASA、新西兰 CAA、法国 DGAC、爱尔兰 IAA 等）加 OpenSky 飞机数据库；Natural Earth 边界；美国人口普查局与 GeoNames 邮编点 |
| 航线 | 机场对画成弧线：线宽是投放座位，颜色是上座率；每条航线的逐月历史、承运人、机型与类别。 | 巴西、美国已上线 | 美国 BTS T-100、巴西 ANAC 统计。下一步：Eurostat avia_par、澳大利亚 BITRE |
| 价值 | 巴西申报成交价，按机型和出售时机龄。 | 已上线 | 巴西 ANAC 航空登记库（RAB） |
| 资产 | 每个运营人：机龄、自有与租赁、飞机抵押债券文件里的评估价与贷款额、租约与债务到期。 | 计划中 | SEC EDGAR（2001 年以来的 EETC 说明书）、开曼与百慕大交易所上市文件、美国进出口银行审批 |
| 实时 | 此刻在飞的飞机；点一架跳到它的注册、所有者和常飞航线。 | 计划中 | OpenSky Network 实时接口 |
| 机会榜 | 上座率长期高于 85%、只有一两家承运人、机龄偏老、租约将到期的航线。每个分数都能点开出处。 | 计划中 | 由以上各层推出 |
机型怎么分类
机型是固定的，所以本页自建了一个机型参照库，以 ICAO 机型代号（Doc 8643）为主键。各登记库对机型的不同写法都对到代号上，主要靠飞机的 24 位地址与 OpenSky 数据库对接。每家航司每种机型的实际客舱座位来自美国 T-100（座位 ÷ 起飞架次）。制造商口径的航程、投入年份、代际还没填；没有出处的数不填。
如实说明的局限
- 国家以下的层级显示的是登记所有者的地址，不是飞机驻地。受托人和租赁公司会让飞机集中在自己的地址。
- 航线级上座率只有美国（含国际航段）、欧盟、巴西和澳大利亚公开；中国、中东和东南亚在加入付费航班数据前是空白。
- 巴西航线的机型类别是按承运人在册机队推断的，因为 ANAC 航线统计没有机型栏。
- 逐架租金没有任何公开来源。资产层会用替代指标并明说。
- OpenSky 数据是众包的、不完整；约 7% 的飞机座位未知，单独成段。
建设顺序
- 机队层与变化流。已完成。
- 航线层，先巴西后美国。已完成；时间轴待做。
- 经 OpenSky 的实时层。
- 资产层与机会榜。
姊妹页：Airline operations（航空业雇主的在招分析岗）· CMBS Property Atlas（同一方法用于商业地产）。