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.

N9230VCloud Surfing Aviation LLC · Costa Mesa, CAS/N 690062 N92318Flitepro Inc · Murrieta, CAS/N 17261561 N9231VShaffer Lawrence · West Des Moines, IABuilt 1969 · S/N 690050 N92324Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 17261562 N9232VFerri Lawrence E · Lake Worth, FLBuilt 1969 · S/N 690056 N9233MSlone Buddie M · Waynesburg, KYBuilt 1966 · S/N 1188 N9233RBlash Gregory J · Corona, CABuilt 1978 · S/N R18200671 N9233VRenner David C Jr · Belleville, ILBuilt 1969 · S/N 690063 N9234MRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1966 · S/N 1189 N9234RRegistration Pending · Maurice, IARegistration pendingBuilt 1975 · S/N 18802173T N92356Hub City Aviation Academy LLC · Lubbock, TXBuilt 1973 · S/N 17261567 N9235VLott William F Jr Trustee · Oklahoma City, OKBuilt 1969 · S/N 690051 N9236HOptic Air LLC · Sioux Center, IABuilt 1975 · S/N 17266034 N9237TVann Dudley C DBA · Greenville, NCBuilt 1978 · S/N 38-78A0286 N9237VPortouw Lawrence J · Huachuca City, AZBuilt 1969 · S/N 690058 N9239VRegistration Pending · Louisville, MSRegistration pendingBuilt 1969 · S/N 690059 N923DFRosene Norm · Chico, CABuilt 1979 · S/N 24-0908 N923EZE Z Air LLC · Wilmington, NCBuilt 1966 · S/N 3458 N923SASunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283708 N923SQSprecher Susan E · Locust Grove, GAS/N 86-73 N9240HPropability One LLC · Daytona Beach, FLBuilt 1975 · S/N 17266038 N9240MMathews Justin R · Omaha, NEBuilt 1966 · S/N 1193 N9240RAir Dakota Flite · Hettinger, NDBuilt 1975 · S/N 18802178T N9241MBellinger John · Wexford, PABuilt 1966 · S/N 3447 N92424Christiansen Cortland · Bakersfield, CAS/N 17261573 N9242HRoland Aviation LLC · Gualala, CABuilt 1975 · S/N 17266040 N9242RAir Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18802180T N9242VHurley Gregory · Capon Bridge, WVBuilt 1969 · S/N 690061 N9243HSeward Air Taxi LLC · Seward, AKBuilt 1975 · S/N 17266041 N9243MHill James C · Grand Saline, TXBuilt 1966 · S/N 1194 N9243RC & L Holzwarth Inc · Virden, ILBuilt 1975 · S/N 18802181T N9243VRedtail Holdings LLC · Mountain Home, ARBuilt 1969 · S/N 690065 N92445Pureflight Aviation Training LLC · Newberg, ORBuilt 1973 · S/N 17261575 N92447American Patrols Inc · Midland, TXBuilt 1973 · S/N 17261576 N92448Eckholt John · Forest Grove, ORBuilt 1973 · S/N 17261577 N9244HCoachron Investments LLC · Grosse Ile, MIBuilt 1975 · S/N 17266042 N9244MAntos Corey · Leland, NCBuilt 1966 · S/N 1195 N9244VGibbs Richard L · Palm Coast, FLBuilt 1969 · S/N 690062 N9245MIneson Thomas · Edgewood, NMBuilt 1966 · S/N 1196 N9246NWestways Aviation LLC · El Cajon, CAS/N 17269246 N9246VBibbs Kevin · Copperas Cove, TXS/N 690063 N92471Shoemaker Floyd · Oneida, TNS/N 17261579 N9248MTaylor Douglas W · Tucson, AZBuilt 1966 · S/N 1197 N9248VBoardman Thomas M · Greenwich, NYBuilt 1969 · S/N 690068 N9249HGencur Paul A · Hudson, OHBuilt 1975 · S/N 17266044 N9249MMaverick Aviation LLC · Richmond, KYBuilt 1966 · S/N 1198 N9249RGreat Plains Applications LLC · Slayton, MNBuilt 1975 · S/N 18802187T N9249VRobertson Scot H · Tribune, KSBuilt 1969 · S/N 690064 N924JWStephenson James M Jr · Hyampom, CABuilt 2000 · S/N 860-2000 N924MCJ Airco LLC · Nashville, TNBuilt 1985 · S/N 17276509

Back to AD 80-25-07 R1