Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N5697QReed Timothy W · Terrell, TXBuilt 1965 · S/N 815 N5697SSilvis Clinton · Austin, TXBuilt 1983 · S/N 24-1412 N5698DGerhart Scott H · Binghamton, NYBuilt 1983 · S/N 24-1414 N5698QCaughell David S · Bartlesville, OKBuilt 1965 · S/N 705 N569MKindred Daniel P · Jacksonville, ILFirst renewal noticeS/N 20-0009 N569NEMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1978 · S/N 15282580 N569TSBig South Fork Aero Inc · Huntsville, TNBuilt 1993 · S/N 722-93 N56BPCeballos Oscar Felipe · San Ysidro, CABuilt 1978 · S/N P21000064 N56CPBulldog Aviation LLC · Goodyear, AZBuilt 1969 · S/N 700003 N56DGEagle East Aviation Inc · North Andover, MABuilt 1976 · S/N 17266239 N56EPSanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17270728 N56FAir Kings LLC · West Chester, PABuilt 1975 · S/N 17265348 N56FASilver Express Co DBA · Miami, FLBuilt 1978 · S/N 172-69682 N56LJL & J Aviation Inc · Atwater, CABuilt 1979 · S/N 17272751 N56MWHeartland Ag Aviation LLC · Lancaster, KSBuilt 1975 · S/N 17265314 N56NLExtra Air LLC · Port Orange, FLBuilt 1977 · S/N R18200084 N56RBTheophilou Philip N · Granbury, TXBuilt 1979 · S/N 24-0777 N56SJShaw Kenneth F · Redding, CABuilt 1999 · S/N 1267-99 N56WGErickson Lynn A · Prairie Du Sac, WIBuilt 2018 · S/N 1474-2018 N5700ERegistration Pending · Fort Lauderdale, FLRegistration pendingBuilt 1978 · S/N 17271923 N5701JBeningfield Alec · Ellicott City, MDBuilt 1983 · S/N 24-1416 N5701QMalters James E · Fulda, MNBuilt 1965 · S/N 763 N5702BCook Richard · Enid, OKBuilt 1983 · S/N 24-1417 N5702QBailey Jacob Kyle · Rosharon, TXBuilt 1965 · S/N 3053 N57033Kale Lunds Aircraft LLC · Phenix City, ALFirst renewal noticeBuilt 1983 · S/N 24-1419 N57038Wattier Nathaniel R · West Palm Beach, FLBuilt 1983 · S/N 24-1420 N57039N57039 LLC · Dover, DEBuilt 1983 · S/N 24-1421 N5705QBlack David W Trustee · Redding, CAS/N 712 N5706QKnox James · Perryton, TXBuilt 1965 · S/N 3055 N57082Wilder Bruce J · Rosamond, CABuilt 1983 · S/N 24-1425 N5708GAir Dakota Flite · Hettinger, NDBuilt 1973 · S/N 18801138 N5708JNelson Kevin B · Aledo, TXBuilt 1983 · S/N 24-1424 N5708QLowry Gregory A · Beaufort, SCBuilt 1965 · S/N 3056 N570CAMidwest Aviation Inc · Mayfield, KYBuilt 2010 · S/N 528-2010 N570MATuminello Joseph A · San Francisco, CABuilt 2005 · S/N 496-2005 N5710QHopper Ronald W · Thousand Oaks, CABuilt 1965 · S/N 3057 N5711HGrand Illusion LLC · Cedar Falls, IABuilt 1983 · S/N 24-1426 N5712QChambliss Walton Aviation Enterprises LLC · Greer, SCBuilt 1965 · S/N 3058 N57135Ligon Brian · Lambert, MTBuilt 1983 · S/N 24-1427 N5714CWatson John G · Shady Shores, TXBuilt 1983 · S/N 24-1428 N5716QEdick Thomas M · Wasco, CABuilt 1965 · S/N 3060 N5717KJavanfard Shawn · Tarzana, CABuilt 1983 · S/N 24-1430 N57183Godair Ronald R · Brighton, MIBuilt 1983 · S/N 24-1431 N57187Reddy Vivek V · Kelseyville, CABuilt 1983 · S/N 24-1432 N5719QHiner Jeffrey N · Salt Lake City, UTBuilt 1965 · S/N 718 N571BMAasjng LLC · Holdrege, NEBuilt 2007 · S/N 1042-2007 N571DMWilliams Stephen C · Georgetown, MEBuilt 2002 · S/N 464-2002 N571LFRegistered aircraftBuilt 2003 · S/N 478-2003 N571SARegistration Pending · Azle, TXRegistration pendingBuilt 2005 · S/N 1009-2005 N5720EInstall Pro Construction LLC · Henderson, NVBuilt 1978 · S/N 17271926

Back to AD 80-25-07 R1