Registered aircraft · 40,472

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N40987Besl Thomas J · Cincinnati, OHBuilt 1973 · S/N 28-7415126 N4098FN4098f LLC · Ypsilanti, MIBuilt 1976 · S/N 28-7715004 N4098XOstgard William R · Mims, FLS/N 5198 N4098ZChant J Archie · Riverton, WYBuilt 1964 · S/N 18-8112 N40993Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405159 N4099EReel Chad · Wasilla, AKS/N 18-7809066 N4099XMiller Aviation Group LLC · Coon Rapids, MNBuilt 1971 · S/N 5199 N4099ZMayes Brett R · Williams, CABuilt 1964 · S/N 18-8113 N409AFThomas Douglas M Jr · Blue Bell, PABuilt 1966 · S/N 28-21915 N409MMStormer Isaac E · Curtis, WABuilt 1981 · S/N 154 N40AWKlingbeil Mark T · Bottineau, NDBuilt 1999 · S/N 1452 N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264 N40CMKline Timothy L · Elverson, PABuilt 1987 · S/N 368 N40CSSoloy L Chris · Wasilla, AKBuilt 1993 · S/N 1 N40CZBeast Aero Consulting And Training LLC · Rosamond, CAS/N 0763 N40DCWright Innovators LLC · Sebastian, FLBuilt 1988 · S/N 561 N40DRRoss David R · Wakeman, OHBuilt 1991 · S/N DR-01 N40DZSt. Bernard Aerial LLC · Kalispell, MTBuilt 1947 · S/N 12-2675 N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569 N40FAWright Paul G Trustee · Scotts Valley, CABuilt 1972 · S/N AA5-0114 N40GECuckler Dale E · Tulsa, OKBuilt 1998 · S/N 1545 N40GRPetao LLC · Trinity, FLBuilt 2003 · S/N 21980 N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309 N40HYHendrickson Dale W · Denton, TXBuilt 2002 · S/N 2205 N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036 N40JKMann Nathan · Poulsbo, WABuilt 2022 · S/N 11480 N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900 N40MBAndersen Thomas · Yoder, COS/N 708 N40MGFly Arkansas LLC · Harrison, ARBuilt 1959 · S/N TD-293 N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170 N40PXHealey David A · Hammondsport, NYBuilt 2003 · S/N 14110C N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241 N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099 N40STAvera Stewart · Pensacola, FLBuilt 1997 · S/N T106A N40VVFaulkner Winthrop S · Anchorage, AKS/N 005 N40VXHarder Steven R Trustee · The Sea Ranch, CABuilt 1998 · S/N 5040 N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829 N4100FGoldberg Mark · Massapequa Park, NYBuilt 1976 · S/N 28-7715006 N4100PValley Flying LLC · Stuarts Draft, VABuilt 1959 · S/N 23-1580 N4100YLofton Charles T · Georgetown, MNBuilt 1976 · S/N 944-76 N4100ZMountain Escape LLC · Pullman, WAS/N 18-8114 N4101JRichardson Howell · Gilbert, AZBuilt 1966 · S/N 28-22413 N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76 N4102PDoran Jeffrey T · Westerville, OHBuilt 1959 · S/N 23-1582 N4103NKarpik Joseph Paul · Floodwood, MNS/N 680074 N4103PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1583 N4104PSpooter Air II LLC · Willis, TXBuilt 1959 · S/N 23-1584 N4104XBandy Carla Sr · Texarkana, TXBuilt 1968 · S/N 201 N4104YBurgett Gary · Galena, AKBuilt 1976 · S/N 945-76 N4104ZZelina William B III · Fort Greely, AKBuilt 1964 · S/N 18-8124

Back to AD 80-04-03 R2