Skip to content

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.

N9469EParker Duane E · Louisville, KYBuilt 1979 · S/N 17272273 N9469HAirplanes And Attitude LLC · Mckinney, TXBuilt 1975 · S/N 17266170 N9469VNorton Curtis S Jr · Beaver Falls, PAS/N 700038 N946ACNaples Air Center Inc · Naples, FLBuilt 1985 · S/N 15286018 N946CHCritchfield Flying Service LLC · Rupert, IDBuilt 1977 · S/N 17269021 N946MSMt San Antonio College · Walnut, CABuilt 2015 · S/N 1411-2015 N946SFSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282353 N946SMEntrekin David C · Ridgeland, MSBuilt 1982 · S/N 17275870 N94714Wright Aero Inc · Saint Cloud, MNBuilt 1983 · S/N 15285771 N9471VJ S Alguire Consulting Forestry Services Inc · Dover, DEBuilt 1970 · S/N 700060 N9472HMulder Terry A · Appleton, WIBuilt 1976 · S/N 17266171 N9473VBarcus Roger L · Saint Paul, MNBuilt 1970 · S/N 700039 N9474BDiehl Greg · Angola, INBuilt 1981 · S/N 172RG0833 N9474VCasa Patrick Greg · Albuquerque, NMBuilt 1970 · S/N 700061 N9475EBerzinis Wayne T · Windham, MEBuilt 1979 · S/N 17272275 N9475TJohnson Marc · Westland, MIBuilt 1978 · S/N 38-78A0109 N94768Indian River Flying Club Inc · Rockledge, FLBuilt 1983 · S/N 15285782 N9476HHelicopter Partners Inc · Wellington, FLBuilt 1975 · S/N 17266172 N9477LSlipstream Aviation LLC · Carrollton, GABuilt 1986 · S/N 17276562 N9477VMurnville Glenlove Flyers Ltd · Delaware, OHBuilt 1970 · S/N 700062 N9478EColeman Richard · Menominee, MIS/N 17272276 N94790Kingsky Flight Academy LLC · Lakeland, FLS/N 15285788 N9479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1978 · S/N 38-78A0110 N947ARPapoi Coral A · Sitka, AKBuilt 1972 · S/N 858-72 N947KCPeterson Cassandra L · Poplar Grove, ILBuilt 2018 · S/N 1412-2018 N947SFSnohomish Flying Service Inc · Snohomish, WABuilt 1983 · S/N 15285770 N9480DKent State University · Stow, OHBuilt 1985 · S/N 172RG1180 N9480EMoyer Aviation Inc · Tobyhanna, PABuilt 1979 · S/N 17272277 N9480HMoynihan Patrick J · Lakeville, MNBuilt 1975 · S/N 17266173 N9480RWestern Montana Orthopaedic LLC · Missoula, MTS/N R18200708 N94814Lint Michael G · Sacramento, CABuilt 1980 · S/N 24-1062 N9481DBoemig Madison K · Dalton, NHBuilt 1985 · S/N 172RG1181 N9481VStutzman Mervin · Kingman, INBuilt 1970 · S/N 700046 N94822Elon Aviation LLC · Burlington, NCBuilt 1983 · S/N 15285795 N9482RWindy Lane Farms Transport LLC · Mulberry, INBuilt 1975 · S/N 18802292T N9482TReid John · Emmett, IDBuilt 1978 · S/N 38-78A0111 N9483TLindley Mark E · Wakefield, RIBuilt 1978 · S/N 38-78A0113 N9483VScholls Arnold W · Syosset, NYBuilt 1970 · S/N 700042 N9483YSioux Falls Technology LLC · Sioux Falls, SDBuilt 1981 · S/N 21064520 N9484HN9484h LLC · Wheeling, ILBuilt 1975 · S/N 17266175 N9484VHannon Fredrick W · Punta Gorda, FLBuilt 1970 · S/N 700064 N9485RStevenson Flying Service LLC · Selden, KSBuilt 1975 · S/N 18802294T N9485VBrown Douglas B · Petaluma, CABuilt 1970 · S/N 700043 N9486BMccoy Robert P · Fairbanks, AKBuilt 1981 · S/N 172RG0837 N9486RAnderson Aerial Spraying Serv Inc · Canby, MNBuilt 1975 · S/N 18802295T N9487RBoyer Air Lc · West Des Moines, IABuilt 1978 · S/N R18200710 N9488GTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17273629 N9488VMarlow Michael L · Bandera, TXBuilt 1970 · S/N 700045 N94891Avcorp Holdings Inc · Jackson, MIBuilt 1983 · S/N 15285806 N9489VReeder John Galen · Cedar Falls, IAS/N 700048

Back to AD 80-25-07 R1