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.

N9007XGustafson Stephen M · Tallulah, LABuilt 1961 · S/N 18253407 N9008CFogleman Brian L · Stonewall, LABuilt 1954 · S/N 31056 N9008HTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2011 · S/N 18282227 N9008MWhaley Steven Todd · De Leon Springs, FLBuilt 1969 · S/N 18052108 N9009CKyer Barry Patrick · Honey Grove, TXBuilt 1954 · S/N 31057 N9009TNelson Landon E · Monument, COBuilt 1960 · S/N 52909 N9009XChick Theodore D DBA · Beulah, NDS/N 18253409 N900DFWaters Aero-Marine Inc · South Thomaston, MEBuilt 1973 · S/N 20700234 N900EDSpradling James · Fremont, OHBuilt 1969 · S/N 18259731 N900HPKansas Highway Patrol · Topeka, KSBuilt 2012 · S/N 20608344 N900MPSweet Fred A · Loves Park, ILBuilt 1981 · S/N 18268093 N900RPCobra Aviation Services LLC · San Angelo, TXBuilt 1978 · S/N 18266414 N9010KMitchell Richard · Voorhees, NJBuilt 2024 · S/N 18283285 N9010MCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 18264641 N9011Kro Bros LLC · Lebanon, OHBuilt 1973 · S/N 18261966 N9011XCowan James H · New Springfield, OHS/N 18253411 N9012CClark Gloria L Trustee · Gillette, WYBuilt 1954 · S/N 31060 N9012GCockrell Carroll G · Mount Sterling, KYBuilt 1970 · S/N 18260552 N9012MMutchler Joseph T · Billings, MTS/N 18052112 N9012XGone Flying LLC · Bartlesville, OKS/N 18253412 N9013CMarch David H · Lincoln, CABuilt 1954 · S/N 31061 N9013TLamb Aaron C · Vail, AZBuilt 1960 · S/N 52913 N9013XSpooner Brian P · Poway, CABuilt 1961 · S/N 18253413 N9014MAvery John W · Fergus Falls, MNBuilt 1970 · S/N 18052114 N9014XSudoh Kenji · Duluth, MNBuilt 1961 · S/N 18253414 N9016CLindblom Carl O · Saxon, WIBuilt 1954 · S/N 31064 N9016GSkydive Duluth Superior LLC · Superior, WIBuilt 1971 · S/N 18260556 N9016MKinslow Aviation LLC · Prague, OKBuilt 1976 · S/N 18264644 N9016TDiaz Mark Adba · Madera, CABuilt 1960 · S/N 52916 N9016XWolfe John G · Tooele, UTS/N 18253416 N9017TCombs Ryan W · Carson City, NVBuilt 1960 · S/N 52917 N9018GSimpkins Lynn DBA · Costa Mesa, CABuilt 1971 · S/N 18260558 N9018MMclain Daniel E · Baden, PABuilt 1976 · S/N 18264646 N90193Renfro Michael W · Bethel, AKBuilt 1969 · S/N 20700007 N9019CHanks Don N · Eagle River, AKBuilt 1954 · S/N 31067 N9019XJudah LLC · Springdale, ARBuilt 1961 · S/N 18253419 N901JMGuderjahn Raymond · Garden Plain, KSBuilt 1962 · S/N 18253901 N901PWFlywerx LLC · Anchor Point, AKBuilt 1969 · S/N 18259980 N901RMBusey Technology Company LLC · Vienna, VAS/N 18282285 N9020GAmeritek LLC · Tuttle, OKBuilt 1971 · S/N 18260560 N9020XBrackett Clayton J · Coopersville, MIBuilt 1961 · S/N 18253420 N9021GRector Edward L · Nederland, TXBuilt 1971 · S/N 18260561 N9022CBarber Theodore C Trustee · Spanish Fork, UTBuilt 1954 · S/N 31070 N9022HTurner Kent B · Addison, TXBuilt 2010 · S/N 18282254 N9022MDaytona Beach Aero Club Inc · Ormond Beach, FLBuilt 1976 · S/N 18264647 N9022THale O'Lele Corp · Honolulu, HIBuilt 1960 · S/N 52922 N9022XPartner 91 LLC · Scottsdale, AZBuilt 1961 · S/N 18253422 N9023CAinsworth Warren B · Vestavia Hills, ALBuilt 1954 · S/N 31071 N9023GBull Bren C · Kingsville, TXBuilt 1971 · S/N 18260563 N9023TBauer John P · Medford, WIBuilt 1960 · S/N 52923

Back to AD 84-10-01 R1