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.

N58GSCranford John · Douglassville, TXBuilt 1979 · S/N R18201412 N58JKWander Aviation LLC · Klamath Falls, ORBuilt 1982 · S/N 18268286 N58MARagan Edwin E III · Austin, TXBuilt 1977 · S/N 21062237 N58MGMullins Tennis Jr · Chapmanville, WVBuilt 1973 · S/N 18262358 N58RRClover Management Systems Inc · Sanford, FLBuilt 1980 · S/N 18267545 N58SDBrusasco John Mario Trustee · Portland, ORBuilt 1958 · S/N 50167 N58TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 21062998 N59007Hang On LLC · Montrose, COBuilt 1973 · S/N 21060014 N59008Davis Burton D · Jefferson, IABuilt 1973 · S/N 21060015 N5900BEnvi Adventures LLC · Troutdale, ORS/N 33900 N5900MBucher Burton W · North Chicago, ILBuilt 1956 · S/N 32330 N59011Nelson Albert N III · Baytown, TXBuilt 1973 · S/N 21060018 N5902FPeters Kenneth R · Plainfield, ILBuilt 1967 · S/N 21058902 N5903BAbidance Inc · Winthrop, WAS/N 33903 N59041Edwards Aviation & Consulting LLC · Broken Arrow, OKBuilt 1973 · S/N 21060044 N59045Air-Zancada Inc · Wilmington, DEBuilt 1973 · S/N 21060046 N59049Scarry David Charles · San Luis Obispo, CABuilt 1973 · S/N 21060049 N5904B98x LLC · Caddo Mills, TXBuilt 1956 · S/N 33904 N5904FRegistered aircraftBuilt 1967 · S/N 21058904 N5904JHodge Marcus · Mansfield, LABuilt 1975 · S/N 18263572 N5905JF92 Aviation Llp · Dover, OKBuilt 1975 · S/N 18263573 N59060Agriflite Services Inc · Wakarusa, INBuilt 1973 · S/N 21060059 N59073Hartenstine Michael Carl · Lancaster, CABuilt 1973 · S/N 21060069 N5907BWarner Aric D · Rosamond, CAS/N 33907 N5907FIsland City Seaplanes Inc · Cordova, AKBuilt 1967 · S/N 21058907 N5908BLifland Kenneth D · Mckinney, TXBuilt 1956 · S/N 33908 N5908FCharger Aviation LLC · Chariton, IABuilt 1967 · S/N 21058908 N5909FHendrix Benton · Eckley, COBuilt 1967 · S/N 21058909 N590CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282171 N590MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608339 N59105Allen Willis M Jr · El Cajon, CABuilt 1973 · S/N 21060093 N5911BKatzer Jamin · Frederick, COBuilt 1956 · S/N 33911 N5911JAveightor LLC · Alba, TXBuilt 1975 · S/N 18263574 N5912BPrice Rand S · Casper, WYBuilt 1956 · S/N 33912 N59141Peters Mark E · Newport News, VABuilt 1973 · S/N 21060118 N59146Universal Charter Service Inc · Auburn, CABuilt 1974 · S/N U20602624 N5914BStrong Brian DBA · Southport, NCBuilt 1956 · S/N 33914 N5914JFreedom One Inc · San Jose, CABuilt 1975 · S/N 18263575 N5915BTaylor Scott G · Draper, UTBuilt 1956 · S/N 33915 N5915FJeffries Phillip L · Belington, WVBuilt 1967 · S/N 21058915 N59164Marine Electrical & Refrigeration Of Kodiak LLC · Kodiak, AKBuilt 1974 · S/N U20602626 N5916FTlc Flying Inc · Colfax, WABuilt 1967 · S/N 21058916 N59173Vogelgesang Randy · Gardnerville, NVBuilt 1973 · S/N 21060141 N5917BHauser Nathan S · Newark, DEBuilt 1956 · S/N 33917 N59180Kennedy Jared W · Cordova, AKBuilt 1980 · S/N 50582 N59181Meader Luke C · Marfa, TXBuilt 1959 · S/N 52085 N59182Abbott James H · Gallatin, TNBuilt 1958 · S/N 51578 N5919BBell Ian E · Rapid City, SDBuilt 1956 · S/N 33919 N591CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282176 N591NCPotto Aviation Inc · Wilmington, DEBuilt 1981 · S/N 18053193

Back to AD 84-10-01 R1