Registered aircraft · 20,484

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.

N184DPRobertson Gary B · Canton, TXBuilt 1975 · S/N 18263817 N184JPSarita Aerial Contractors Inc · Casa Grande, AZBuilt 1979 · S/N 18052889 N184PWCardwell Aubrey Lynn · Spring Branch, TXBuilt 1979 · S/N 18266871 N184RDAfrican Parks Aviation Trustee · Cheyenne, WYBuilt 1999 · S/N 18280466 N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302 N1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 21058752 N1852XPhillips Lane · Dawson, TXBuilt 1965 · S/N 18255952 N1853QSend North · Anchorage, AKBuilt 1975 · S/N U20602943 N1854FHarlan Bradley J · New Brighton, MNBuilt 1966 · S/N 21058754 N1854ZBargabos William M · Wasilla, AKS/N 2050054 N1856XRobert Yost Enterprises · Saint Francis, KSBuilt 1964 · S/N 18255956 N1857RNoetic Aviation LLC · Seattle, WABuilt 1978 · S/N R18200581 N1858XSalem Aero Club Inc · Bridgeton, NJBuilt 1964 · S/N 18255958 N1858ZPairofminutes LLC · Marshville, NCS/N 205-0058 N1859FBaker Robert J · Ogema, MNBuilt 1966 · S/N 21058759 N185AAEoff Joe · Salem, ORS/N 185-0881 N185ALBohannon James A III · Montgomery, TXBuilt 1961 · S/N 185 0047 N185BCShackelford John S · Roanoke, TXBuilt 1961 · S/N 1850021 N185CQAndreshak John L · Soldotna, AKBuilt 1962 · S/N 1850400 N185CRRegistered aircraftBuilt 1962 · S/N 185-0335 N185CTN185ct LLC · Hollis, NHBuilt 1962 · S/N 185-0330 N185DLLong Steven W · Sheridan, MIBuilt 1964 · S/N 1850690 N185EEThinair Ventures LLC · Kalispell, MTBuilt 1961 · S/N 1850105 N185EMAikins Laurie R · Bonners Ferry, IDBuilt 1961 · S/N 1850078 N185FKennedy Riley F · Lubbock, TXBuilt 1957 · S/N 50123 N185FCAlaska Dream Center · Wasilla, AKS/N 185-0982 N185GBelz John W · Salt Lake City, UTBuilt 1961 · S/N 1850163 N185GCChennault Flying Services LLC · Colorado Springs, COBuilt 1965 · S/N 1850802 N185GMMandes George J · Homer, AKBuilt 1962 · S/N 185-0424 N185HHCoyne Greg · Hondo, TXBuilt 1961 · S/N 1850049 N185MKVermillion Brandt T · Amarillo, TXBuilt 1962 · S/N 1850455 N185NVLanding Gear Works LLC · Renton, WABuilt 1965 · S/N 185-0984 N185PTHansen Peter N · Wellington, NVBuilt 1964 · S/N 185-0760 N185QBMcinelly Jessica N · Anchorage, AKS/N 185-0131 N185RAA-T Enterprises Ltd · Three Forks, MTBuilt 1967 · S/N 185-1209 N185RHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1962 · S/N 185-0413 N185SNJones Kyle H · Anchorage, AKBuilt 1972 · S/N 185-01943 N185TADash Aero LLC · Lewes, DEBuilt 1965 · S/N 185-0925 N185URamin Reuben F · Tomball, TXBuilt 1961 · S/N 185-0230 N185UVClark Stanley E Trustee · Redmond, ORBuilt 1961 · S/N 185-0171 N185WBFodor Scott M · Barryton, MIBuilt 1980 · S/N 18504105 N185YTSutton Aircraft Salvage LLC · Palmer, AKS/N 185-0145 N185ZAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1965 · S/N 185-0983 N1861XCabreja Sanchez Elmer · Carolina, PRBuilt 1964 · S/N 18255961 N1861ZPadden Geary L · Duluth, MNBuilt 1962 · S/N 205-0061 N1862XCose Gary D · Livermore, CABuilt 1964 · S/N 18255962 N1863FAndersen Dana K · Scappoose, ORS/N 21058763 N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764 N1865XAria & Arjun LLC · Cumming, GABuilt 1964 · S/N 18255965 N1865ZBpf Equipment LLC · Burnet, TXBuilt 1962 · S/N 205-0065

Back to AD 84-10-01 R1