Registered aircraft · 20,481

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.

N9885MTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1976 · S/N 18264783 N9886CAlm Ronald · Kuna, IDBuilt 1978 · S/N R18200482 N9886EHodson Don W · Marion, KSBuilt 1975 · S/N 18263947 N9886MJohnson Leroy W · Nelson, NES/N 18264784 N9887CLeonard Paul A Jr · Grand Beach, MIBuilt 1978 · S/N R18200484 N9888CLoehde Thomas · Lolo, MTBuilt 1978 · S/N R18200485 N9888EHarrison Cladis · Westfield, NJBuilt 1975 · S/N 18263949 N98896Two Tails LLC · Las Vegas, NVBuilt 1998 · S/N 18280350 N9889EDragonstone LLC · Beaverton, ORBuilt 1975 · S/N 18263950 N9889MFree Lutheran Association Of Pilot Supporters Inc · Plymouth, MNBuilt 1976 · S/N 18264786 N9889VWebb Matthew K · Denton, TXBuilt 1966 · S/N 188-0139 N9889YTharp Rodney W · Thomasville, NCBuilt 1981 · S/N 21064629 N988BZRauh William · New Hope, PABuilt 2011 · S/N 18282305 N988MTurecek Peter J · Fairfield, CTS/N R18201357 N988MVMiller James A · Granada Hills, CABuilt 1967 · S/N T210-0284 N988PSStartz Paul D · Douglasville, GABuilt 1956 · S/N 33749 N988RAFifteen-Sixty LLC · Ottawa Hills, OHBuilt 1997 · S/N 18280022 N988TCSpaulding Bernard B · Terrell, TXBuilt 1998 · S/N 18280297 N9890ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 18268465 N9890HDe Rico Nicolas · Tracy, CABuilt 1981 · S/N 18268094 N9890MR & R Brown Inc · Sun Valley, IDBuilt 1977 · S/N 21062085 N9890XSelman Jett · Anchorage, AKBuilt 1961 · S/N 1850090 N9890YValiair Lc Trustee · Casper, WYS/N 21064630 N9892AMiner Jay G · Seattle, WABuilt 1950 · S/N 7595 N9892MBogner Aviation LLC · Dover, DEBuilt 1976 · S/N 18264789 N9893HBain Aviation Inc · Weiser, IDBuilt 1981 · S/N 18268095 N9894AHealdsburg Aviation · Healdsburg, CABuilt 1950 · S/N 7597 N9894EDebski Matthew B · Belmont, CABuilt 1975 · S/N 18263955 N9894YRaymond Andy · Council Bluffs, IABuilt 1981 · S/N 21064632 N9895ETurnkey Aviation LLC · North Las Vegas, NVBuilt 1985 · S/N 18268467 N9896HHilltop Aviation LLC · Rowlesburg, WVBuilt 1981 · S/N 18268097 N9896XKing Kevin J · Angle Inlet, MNBuilt 1961 · S/N 1850096 N9897AAero Garage Inc · Fort Myers, FLBuilt 1950 · S/N 7602 N9897MAcme Aviation USA LLC · Nashville, TNBuilt 1976 · S/N 18264794 N9898ELamar Rosa E · Santa Paula, CAS/N 18263958 N9899HCrimson Aircraft Sales LLC · Tuscumbia, ALBuilt 1981 · S/N 18268098 N989CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282116 N989RAAvco Patrol LLC · Lyndon, KSBuilt 1997 · S/N 18280035 N989SDFlyby Equipment LLC · Factoryville, PABuilt 1957 · S/N 34207 N98DDReady Aim Flyer LLC · New Castle, DES/N 51709 N98GPHammack Philip Scott · Canton, MSS/N R18201593 N98MLPlr Services LLC · Stuart, FLBuilt 2019 · S/N 18283066 N98TCPositiv8 LLC · Wilmington, DEBuilt 1974 · S/N 18263411 N98TDLewis John Cory · Modesto, CABuilt 1998 · S/N 18280081 N98VFFitzpatrick Patrick D · Titusville, FLBuilt 2025 · S/N 18283316 N98WHN94ee LLC · West Palm Beach, FLBuilt 1998 · S/N 18280122 N98WYCheyenne Flying Club LLC · Cheyenne, WYBuilt 1998 · S/N 18280339 N9900BS & L Aviation LLC · Buhl, IDS/N 34300 N9900NRegistered aircraftBuilt 1975 · S/N 18052555 N9900THamlin Timothy B · Garden City, KSBuilt 1960 · S/N 53000

Back to AD 84-10-01 R1