Registered aircraft · 20,486

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.

N1233BSutton Aircraft Salvage LLC · Palmer, AKS/N 51215 N1233FFlyboyz LLC · Bourbon, MOS/N 182-61270 N1233MFrench Rollie T · Vermillion, SDBuilt 1975 · S/N 18264251 N1233WDouble Crown Investments LLC · Earlsboro, OKBuilt 1970 · S/N 18260263 N1234FSkydive New Hampshire LLC · Moab, UTS/N 33444 N1236MRutherford Dustin · Simi Valley, CABuilt 1975 · S/N 18264252 N1237MJ&C Walker Aviation LLC · Henderson, TXBuilt 1977 · S/N 21061927 N1239MMonarch M Miller · Ocala, FLBuilt 1975 · S/N 18264254 N123ARRullan Alberto · Adjuntas, PRBuilt 1998 · S/N 18280232 N123CEBas Part Sales LLC · Greeley, COS/N 21061054 N123DBN123db LLC · Madison, NJBuilt 1973 · S/N 18262088 N123DDCenturion 123 LLC · Glenwood Springs, COBuilt 1974 · S/N 21060627 N123DLNiche Advertising Solutions Inc · Statesboro, GABuilt 1969 · S/N 18259340 N123DMJacquin Philip Fink · New York, NYS/N 21062663 N123GLAir Care Leasing LLC · Lamar, COBuilt 1973 · S/N 18261902 N123JTGraham Richard A · Wichita Falls, TXBuilt 1965 · S/N T210-0019 N123KLWings Over The Rockies LLC · Wittmann, AZBuilt 1977 · S/N 18265746 N123KTHolliday Paul B · Kiln, MSBuilt 1963 · S/N 21058218 N123LJRegistered aircraftBuilt 1965 · S/N 18051526 N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N123TMJaars Inc · Waxhaw, NCS/N U20601768 N123TZSouthside Truck And Trailer Inc · San Antonio, TXBuilt 2004 · S/N 18281327 N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004 N123UPApache Underground And Excavating LLC · Lakeside, AZBuilt 1969 · S/N 18259985 N123VJKopp Daniel D · Buckeye, AZBuilt 1965 · S/N 18256102 N123VRLewis Edward M · Mesquite, NVS/N 210-59891 N123WGThornhill Shaun · Greenville, OHBuilt 1963 · S/N 18254997 N1240MElk Creek Investments LLC · Helena, MTBuilt 1975 · S/N 18264255 N1242MHenninger Bradley J · Green Cove Springs, FLS/N 18264256 N1243MRegistered aircraftBuilt 1975 · S/N 18264257 N1245BPositive Flight LLC · San Ramon, CABuilt 1975 · S/N 18264060 N1245SMccain Michael E · Sun Valley, NVBuilt 1976 · S/N 18264814 N1247SShurma Ramesh · Hayward, CABuilt 1976 · S/N 18264816 N1248EBoling Derek · Paragould, ARBuilt 2005 · S/N 18281590 N1248SBodolay John M · Fredericksburg, VABuilt 1976 · S/N 18264817 N1249SClemans Alan J · Guymon, OKBuilt 1976 · S/N 18264818 N124BSLeair LLC · Eufaula, ALBuilt 2004 · S/N 18281390 N124EFGuerrer Daniel S · Redondo Beach, CABuilt 1998 · S/N 18280315 N124HKDavid A Desimone LLC · Newnan, GAS/N R18201621 N124KChicken Hawk Aviation LLC Series 2 · Waxahachie, TXBuilt 1975 · S/N 18263803 N124SKAgarwal Sanjai K · Monroe, NJBuilt 2025 · S/N 18283304 N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355 N124WJSessions Thomas Eric Trustee · Huffman, TXBuilt 2004 · S/N 18281475 N124WMDenton James Manley Jr · Cabot, ARBuilt 2016 · S/N 18282431 N124WNTemple Steve D · Superior, MTBuilt 1972 · S/N U206-01832 N1250MBlakley John · Cascade, IDBuilt 1963 · S/N 18051213 N1250SNew Oasis Market Inc · Blacksburg, VABuilt 1976 · S/N 18264819 N1250WScherff Lewis H Trustee · Inver Grove, MNBuilt 1964 · S/N 18051429 N1251BJagow Charles Philip · Fairbanks, AKBuilt 1966 · S/N 18051756 N1251DErjoaero LLC · Stuart, FLBuilt 2007 · S/N 18282023

Back to AD 84-10-01 R1