Skip to content

Registered aircraft · 22,416

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N6857JSkyward3 LLC · Kalispell, MTS/N 28R7635341 N6857WN6857w Inc · Palos Heights, ILBuilt 1965 · S/N 28-21013 N6859JDobberfuhl Roy · Cedarburg, WIBuilt 1976 · S/N 28-7625247 N685FLDadson Tach LLC · Mesa, AZBuilt 1971 · S/N 28-7125619 N685JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020085 N685LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881252 N685MAYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020143 N685NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881305 N6860JApm Leasing LLC · Casper, WYBuilt 1976 · S/N 28-7690413 N6861FParker Helicopters Inc · Watsonville, CAS/N 28-7790168 N6861JEwart Mark A · Shoreacres, TXBuilt 1976 · S/N 28-7690414 N6861WLoffeimancher Richard P · Eastvale, CABuilt 1965 · S/N 28-21017 N6862JTraut Joseph W · Sharon, MABuilt 1976 · S/N 28R-7635353 N6862WFly Dynasty Corp · Ocala, FLBuilt 1965 · S/N 28-21018 N6863FKaminski Joseph J · Port Orange, FLBuilt 1976 · S/N 28-7790169 N6863WThrust Vector LLC · Austin, TXFirst renewal noticeBuilt 1965 · S/N 28-21019 N6864JHudson Phillip Jr · Cookeville, TNBuilt 1976 · S/N 32-7640104 N6865JPlanepals LLC · Waverly, MOBuilt 1976 · S/N 32R-7680372 N6865WGraves William · Highlands, TXBuilt 1965 · S/N 28-21021 N6867JOtmane Lahouari · Orlando, FLBuilt 1976 · S/N 28-7625248 N6868DFlamingo Air Inc · Cincinnati, OHBuilt 1969 · S/N 32-40608 N6868KFlamingo Air Inc · Cincinnati, OHBuilt 1973 · S/N 28-7325260 N68690Locaero Services Inc Trustee · Wilmington, DEBuilt 1994 · S/N 2890203 N6869JNa Aviation LLC · Mount Vernon, OHBuilt 1976 · S/N 28-7615381 N6869WRegistered aircraftS/N 28-21025 N686CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881130 N686JMavity Michael D · Phoenix, AZBuilt 1988 · S/N 2816038 N686JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020086 N686LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881253 N686NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881152 N686QPZero2knots Aviation LLC · Canal Winchester, OHBuilt 1979 · S/N 28R-7931289 N6870JCentral Minnesota Aviation LLC · Paynesville, MNBuilt 1976 · S/N 28-7615382 N6871JRyan Air Ventures LLC · Auburn, GABuilt 1976 · S/N 28R-7635354 N6871WSkylux Aviation LLC · Coppell, TXBuilt 1965 · S/N 28-21027 N6872WMergen Andrew John · Colorado Springs, COBuilt 1965 · S/N 28-21028 N6873CMabry Roger Louis Jr · Norwood, NCBuilt 1978 · S/N 32R-7885034 N6873WUptegrove James L · Susanville, CABuilt 1965 · S/N 28-21029 N6874CHuebner Charles P · Grosse Pointe Farm, MIBuilt 1978 · S/N 32R-7885035 N6874WEra Aviation LLC · Downers Grove, ILBuilt 1965 · S/N 28-21030 N6876JN6876j LLC · Provo, UTBuilt 1976 · S/N 28-7690417 N6877FAces Full Inc · Deadwood, SDBuilt 1976 · S/N 32-7700004 N6877WFriedrich David Paul · Frankfort, INBuilt 1965 · S/N 28-21033 N6878JLake Stephen · Geary, OKBuilt 1976 · S/N 28R-7635355 N6879CParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816437 N6879JJackson Evan · Gaston, INBuilt 1976 · S/N 32R-7680376 N687BHTrmg Consulting Services LLC · Edison, NJS/N 28R-7737042 N687JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020087 N687LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881266 N687TJMirarchi Joseph F · New Braunfels, TXBuilt 1977 · S/N 28R7703235 N6880JRobertson Ed J · Owasso, OKBuilt 1976 · S/N 32R-7680377

Back to AD 87-08-08 R3