Registered aircraft · 25,368

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.

N948RRed Baron LLC · Middletown, DEBuilt 1978 · S/N 177RG1318 N948SMScenic Concepts LLC · La Crosse, WIBuilt 1982 · S/N 172RG1057 N9490DMehrer Fritz J · El Cajon, CAS/N 172RG1185 N9490HNovak Rickson J · Pine City, MNBuilt 1975 · S/N 17266177 N9492HSchodack Aviation Association · Ghent, NYBuilt 1975 · S/N 17266178 N9492VRivera Jaime · San Antonio, TXBuilt 1970 · S/N 700066 N9494GKelly William W · Springfield, ORBuilt 1977 · S/N 15279527 N9494VDoerr Jim · Austin, TXBuilt 1970 · S/N 700049 N94959Lane Community College · Eugene, ORBuilt 1983 · S/N 15285823 N9495DEichholz Kenneth D · Cordova, TNBuilt 1985 · S/N 172RG1187 N9495HNelson Flying Service LLC · Lansford, NDBuilt 1975 · S/N 17266180 N9495VSoccer Goals LLC · Christoval, TXBuilt 1970 · S/N 700067 N94963Twin Cities Air Service LLC · Gray, MES/N 15285825 N9496VEvans Richard I · Elko, NVS/N 700050 N9498GSak III LLC · Miller, SDS/N 18801503T N9498VMoonshiner Aviation LLC · Austin, TXBuilt 1970 · S/N 700068 N9498YRamsgate Ltd · Sedalia, COBuilt 1981 · S/N 21064522 N9499VBerliner Donald D · Medford, NJBuilt 1970 · S/N 700048 N9499YMilhouse Richard J · Aguila, AZBuilt 1981 · S/N 21064523 N949CDDupont Samuel F C · Mount Solon, VABuilt 1978 · S/N 17270883 N949MWMgm Landing LLC · Lewes, DEBuilt 2014 · S/N 1143-2014 N949SFRasmussen Agribusiness Inc · Antelope, MTBuilt 1979 · S/N 21063515 N949SMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 172RG0713 N94BMRambarran Brian · Clarence Center, NYBuilt 2008 · S/N 1066-2008 N94BRSingletrack Aviation LLC · Brecksville, OHBuilt 2025 · S/N 1487-2025 N94CPAhlhorn Travis Wayne · New Braunfels, TXBuilt 1979 · S/N 17273150 N94ERHill Andrew T · Smithville, TXBuilt 1983 · S/N 17276053 N94GKBeech Baron LLC · Wilmington, NCBuilt 2022 · S/N 1206-2022 N94HFDefenbaugh Matthew J · Biggsville, ILBuilt 1979 · S/N 1153-79 N94HJGable Taylor Lee · Nicholson, GABuilt 1975 · S/N 17265633 N94PSBrierley Michael G Trustee · Sparks, NVBuilt 1980 · S/N P21000469 N94REMckinney Charles A · Indiana, PABuilt 1980 · S/N 24-1071 N94SAInternational Air Services Inc Trustee · Carson City, NVS/N 227 N94TSPetersen Andrew John · Saint Paul, MNS/N 17259814 N95005Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 15285835 N9500GEphbaugm Equipment LLC · Hartline, WABuilt 1974 · S/N 18801504T N9500MZoom Thusiasts LLC · Smyrna, GABuilt 1967 · S/N 670258 N9501MCasterline Douglas J · Kansas City, MOBuilt 1966 · S/N 670078 N9501SLarue Guy D · Tulalip, WAS/N 7ECA-240 N95021Space Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 15285838 N9502BGraceffa Salvatore · Atascadero, CABuilt 1981 · S/N 172RG0839 N9502HYoung Roger A II · Wasilla, AKFirst renewal noticeBuilt 1975 · S/N 17266182 N9502MStorer Daniel A · Guthrie, OKBuilt 1966 · S/N 670079 N9502SWatson Troy L · Midlothian, TXBuilt 1965 · S/N 7ECA-243 N9502YBci Aviation LLC · Arroyo Grande, CABuilt 1981 · S/N 21064525 N95031Pratt John · Anchorage, AKBuilt 1984 · S/N 15285841 N9503MCurell Kenneth E · Centerville, OHBuilt 1966 · S/N 670080 N9504HPatterson Clifford Wayne · Murphy, TXBuilt 1975 · S/N 17266184 N9504MNawratil Nicholas · Richmond, TXBuilt 1966 · S/N 670081 N9504TWilloughby Dan J · Linden, MIBuilt 1978 · S/N 38-78A0119

Back to AD 80-25-07 R1