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.

N42304Ratcliff John · Rincon, GABuilt 1968 · S/N 18258954 N42305Registered aircraftBuilt 1973 · S/N 18052339 N42306Wright Nolene L Trustee · Wright, WYBuilt 1968 · S/N 18258956 N42311Murphy Kenneth E · Pahrump, NVBuilt 1968 · S/N 18258959 N42313Altitude Enterprises LLC · Omaha, NEBuilt 1968 · S/N 18258961 N42314Mackenzie Jeffrey S · Woodland, MIBuilt 1968 · S/N 18258962 N42317Meyers Brad C · Reno, TXBuilt 1968 · S/N 18258963 N42323Gardiner Russell J · Phoenix, AZS/N 18258965 N42325Henry Nolan T · Ashland, ORS/N 18258967 N42326Hooper James Carl · Webster, MNBuilt 1968 · S/N 18258968 N42328High Tony W · Walters, OKBuilt 1968 · S/N 18258969 N42335Gubernat John F Jr · Pepperell, MABuilt 1968 · S/N 18258971 N42349Skylane 49 LLC · Glenwood Springs, COBuilt 1968 · S/N 18258976 N42359Lincoln Roger Trustee · Gildford, MTBuilt 1973 · S/N 18052343 N42364Smathers Geoffrey R · Mars, PABuilt 1968 · S/N 18258986 N42368Madson Chris J · King City, CABuilt 1968 · S/N 18258988 N42369Hecker Darin · Grants Pass, ORBuilt 1968 · S/N 18258989 N42371Optum Sun LLC · Laguna Hills, CAS/N 18258990 N42376Johnson Lytle D · Anacortes, WABuilt 1973 · S/N 18052348 N42379Wh Land Holdings LLC · Kirbyville, TXBuilt 1968 · S/N 18258996 N42380Payne Patricia C · Spokane, WABuilt 1968 · S/N 18258997 N42381Anthony David W · Wasilla, AKFirst renewal noticeS/N 18258998 N42382Nb Services LLC · Sumrall, MSBuilt 1968 · S/N 18258999 N42387Bernau Jeff A · Kalispell, MTS/N 18259000 N42397Brissey Forrest L · Woodinville, WABuilt 1968 · S/N 18259003 N423CMHurricane Creek Flying Club LLC · Walla Walla, WABuilt 2000 · S/N 20608109 N423LL79bravo Leasing LLC · Lincoln, DEBuilt 1975 · S/N 18264071 N42400Smith Randolph L · Orovada, NVBuilt 1968 · S/N 18259004 N4240142401 LLC · Hailey, IDBuilt 1973 · S/N 18052350 N42409Ross Leslie W · Truckee, CAS/N 18259006 N42421Registered aircraftBuilt 1968 · S/N 18259011 N42424Bowyer Charles W Stephen · Tucson, AZBuilt 1968 · S/N 18259013 N42428Hantzsche Jackson R · Wellington, NVBuilt 1968 · S/N 18259014 N42441Grizard Diane M · Simi Valley, CABuilt 1968 · S/N 18259018 N4244CBusking Ryan · Houston, TXBuilt 1978 · S/N R18200341 N4244SGolden Eagle Outfitters Inc · Delta Junction, AKS/N U20603814 N4245CLogan Gregory A · Chouteau, OKBuilt 1978 · S/N R18200342 N42460Leofsky Richard J · Willis, TXBuilt 1968 · S/N 18259024 N42461Eurice Brian R · Bradenton, FLBuilt 1968 · S/N 18259025 N42464Gunderson Gunnar Jr · Wrangell, AKBuilt 1973 · S/N 18052356 N42465Nadalin David D · North Fort Myers, FLBuilt 1968 · S/N 18259027 N4246CDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1978 · S/N R18200343 N42471Livestock Innovations Inc · Easton, MNBuilt 1968 · S/N 18259030 N42482Dancing Bear Market Inc · Fresno, CABuilt 1968 · S/N 18259033 N42484Hiemstra Ralph W · Sonora, CAS/N 18259035 N42485Kaiser Enterprises Inc · Carrollton, MOBuilt 1968 · S/N 18259036 N42486Armstrong Kevin L · Corvallis, ORBuilt 1973 · S/N 18052357 N4248CSchneider Franz E · Bacliff, TXBuilt 1978 · S/N R18200345 N4248LOney Marilyn S · Beach City, OHBuilt 1970 · S/N 18260226 N42492Mcdermott Brian D · Fairbanks, AKBuilt 1968 · S/N 18259042

Back to AD 84-10-01 R1