Skip to content

Registered aircraft · 25,369

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.

N7591FFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeBuilt 1970 · S/N 210-70 N7591GRochez Gerald A · Jensen Beach, FLBuilt 1970 · S/N 17259291 N7591NJones Michael D · Southern Pines, NCBuilt 1979 · S/N 21063240 N7591VHallack Daniel Edwin · Hart, MIBuilt 1976 · S/N 177RG0882 N75922Phillips Lester L · Pahrump, NVBuilt 1976 · S/N 17268045 N75925A&A Aviation LLC · Edinburgh, INBuilt 1976 · S/N 17268047 N75926Owens Flight Training LLC · Lafayette, LABuilt 1976 · S/N 17268048 N7592RInternational Security Network Inc · Pahrump, NVBuilt 1978 · S/N R18200654 N7592VMisener Richard H · Hermiston, ORBuilt 1976 · S/N 177RG0883 N7592YClover Park Technical College · Lakewood, WABuilt 1977 · S/N R18200141 N75930Rivera Aniceto · Boonton, NJBuilt 1976 · S/N 17268052 N75931Alston Russell R · South Jordan, UTS/N 17268053 N75938Fiedler Aviation LLC · Suffolk, VABuilt 1976 · S/N 17268055 N7593EFrench Robert J · Ferndale, WABuilt 1978 · S/N 17272113 N7593VBlanzy Paul J · Highland, MIBuilt 1976 · S/N 177RG0884 N75942Ward Sharon A · Lago Vista, TXBuilt 1976 · S/N 17268058 N75943Savage Island Airport (Vt15) LLC · Burlington, VTBuilt 1976 · S/N 17268059 N75944Noll Gregory Lloyd · Watford City, NDBuilt 1976 · S/N 17268060 N7594FPierschbacher Clifton A · Marysville, WABuilt 1970 · S/N 237-70 N7594VSilly Boy Aviation LLC · Moses Lake, WABuilt 1976 · S/N 177RG0885 N75950West John T · Bulverde, TXBuilt 1976 · S/N 17268063 N75951Newman James D · El Cajon, CAS/N 17268064 N75955Belgarde Monte G · Butte, MTBuilt 1976 · S/N 17268067 N75956Millennium Aviation Group LLC · Wallace, NCBuilt 1976 · S/N 17268068 N75967Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1976 · S/N 17268073 N75971Price Ronald Anthony · Deer Park, WABuilt 1976 · S/N 17268075 N75972Aircraft Resource Center Inc · Lakeville, MNBuilt 1976 · S/N 17268076 N75974733et LLC · Columbus, OHS/N 17268077 N75976Suburban Aircraft Leasing And Sales LLC · Sylvania, OHBuilt 1976 · S/N 17268079 N7597FKnowles Ross Martin · Chapmanville, WVS/N 743-70 N7597XPlain Company Ltd · Bloomfield Hills, MIBuilt 1977 · S/N R18200111 N75982Schurr Frank J · Las Vegas, NVBuilt 1976 · S/N 17268083 N75985Pitt Patrick L · Ephrata, WABuilt 1976 · S/N 17268086 N7598FDoggett Jacob R · Kingwood, TXS/N 744-70 N7598GGbc Leasing LLC · Gun Barrel City, TXBuilt 1970 · S/N 17259298 N7599FN7599f LLC · Camarillo, CABuilt 1970 · S/N 745-70 N7599GJones James D · Linden, NCBuilt 1970 · S/N 17259299 N7599NAir Conejos Inc · El Paso, TXBuilt 1979 · S/N 21063243 N759EEAcadiana Technical College · Lafayette, LABuilt 1979 · S/N R18201241 N759STraining Planes LLC · Tampa, FLBuilt 1974 · S/N 17264166 N75ALTeebagy Steven C · Wellington, FLBuilt 1973 · S/N 17701927 N75BFScussel Edward D · Albuquerque, NMBuilt 1975 · S/N 792-75 N75DAHenderson John L · Ozona, TXBuilt 1979 · S/N 21063172 N75DFShelley Michael D · Murfreesboro, TNBuilt 1964 · S/N 290 N75ERFaulkner John · Urbana, OHBuilt 1977 · S/N 17269776 N75GKGrecor LLC · Ashville, ALBuilt 2026 · S/N 1229-2026 N75LGMarr Lance · Portland, ORBuilt 1978 · S/N P21000015 N75MMDonney Tom J · Sturgis, SDBuilt 1975 · S/N 824-75 N75NSJohnson Dale B · Steele, NDBuilt 1968 · S/N 17257539 N75RCJoffe Zalman · Bahama, NCBuilt 1981 · S/N 21064325

Back to AD 80-25-07 R1