Skip to content

Registered aircraft · 20,483

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

N3004BDirksen Daniel L · Montevideo, MNBuilt 1952 · S/N 7887 N3004FN3004f LLC · Cranberry Township, PABuilt 1966 · S/N 18257104 N3005BStreamline Aviation LLC · Battlefield, MOS/N 7888 N3005FE & E Jones Farms LLC · Munford, ALBuilt 1966 · S/N 18257105 N3006BMabry Thomas Coleman II · Atlanta, GABuilt 1952 · S/N 7889 N3006QHarrington Michael L · Twin Falls, IDS/N 18258006 N3006YWissner Martin L · Carpenter, WYBuilt 1963 · S/N 18255082 N3007FTroelstra Frederick D · Queensbury, NYBuilt 1966 · S/N 18257107 N3008YWidmier Kolby J · Price, UTBuilt 1962 · S/N 18254008 N300BWWatson Brent J · Bountiful, UTBuilt 1965 · S/N 18256725 N300DFDowner Justin W · Berthoud, COBuilt 1966 · S/N 18257109 N300EMMark Thomas Productions LLC · Ketchum, IDBuilt 1966 · S/N 18257529 N300EPVan Anda Aviation LLC · Apopka, FLBuilt 2000 · S/N 18280903 N300EW2f Trade LLC · Collinsville, TXS/N 21061219 N300HCPs Air LLC · Evansville, INBuilt 1983 · S/N 21064804 N300KTKarnowski Ventures LLC · Manhattan, KSBuilt 1963 · S/N 18255095 N300TDContinental Aerospace Technologies Inc · Mobile, ALBuilt 1978 · S/N 18266128 N300WFAmoth Kurt J Trustee · White Salmon, WABuilt 1997 · S/N 18280015 N3010BEuroaviation Inc Trustee · KematenBuilt 1952 · S/N 7893 N3011BCarney Jeffrey · Langhorne, PABuilt 1952 · S/N 7894 N3011YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1962 · S/N 18254011 N3013FElwell David L · Coolidge, AZFirst renewal noticeBuilt 1966 · S/N 18257113 N3013YHolloway Gregory R · Brenham, TXBuilt 1962 · S/N 18254013 N3014EConstantine Carl A · Arroyo Grande, CABuilt 1982 · S/N 18268226 N3014FBrown Kimberly L · Tucson, AZBuilt 1966 · S/N 18257114 N3014QBilly B Services LLC · Cornelia, GABuilt 1967 · S/N 18258014 N3015BDaniel Thompson G Jr · Greensboro, NCBuilt 1952 · S/N 7898 N3015YBaines Larry R · Antioch, CABuilt 1962 · S/N 18254015 N3016FLosleben William L · Duvall, WABuilt 1966 · S/N 18257116 N3016QBarnes David L · Palmer, AKBuilt 1967 · S/N 18258016 N3016YWood James D · Mineral Bluff, GABuilt 1962 · S/N 18254016 N3018FDietzler James J · Weyauwega, WIBuilt 1966 · S/N 18257118 N3018QAndre Eric J · Somerset, WIBuilt 1967 · S/N 18258018 N3018YGranger Airplane LLC · Granger, INBuilt 1962 · S/N 18254018 N3019FMadison Richard Christopher · Little Rock, ARBuilt 1966 · S/N 18257119 N3019QHatfield Brothers LLC · Gooding, IDBuilt 1967 · S/N 18258019 N301EBQuesnel William G · Truckee, CABuilt 1978 · S/N 21062524 N301GASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18052490 N301PLCutbirth David B · Monahans, TXBuilt 1966 · S/N P206-0334 N301RS2f Trade LLC · Collinsville, TXS/N 21062473 N3020YJ & T Sullivan Farms Gp · Macon, TNBuilt 1962 · S/N 18254020 N3021BChase 13 LLC · Wilmington, DES/N 7904 N3021FRegistered aircraftBuilt 1966 · S/N 18257121 N3021QPicco Anthony · Sykesville, MDBuilt 1967 · S/N 18258021 N3021YBrancao Bryan A · Norco, CABuilt 1962 · S/N 18254021 N3022EBoulais Aaron · Upland, CABuilt 1982 · S/N 18268227 N3023BWelch Thomas R · Modesto, CABuilt 1952 · S/N 7906 N3023FJones Clinton D · Santa Rosa Beach, FLBuilt 1966 · S/N 18257123 N3023YMorgan Lee Blanchard · Albuquerque, NMFirst renewal noticeS/N 18254023 N3024FSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257124

Back to AD 84-10-01 R1