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.

N4904QFoxtrot Air LLC · Highmore, SDBuilt 1976 · S/N 18802639T N4904SO Neil Mark F · Suffolk, VABuilt 1979 · S/N R18201444 N49055Lima Aviation LLC · Lake Havasu City, AZBuilt 1977 · S/N 15281126 N4905CAnacapa Capital LLC · Fresno, CABuilt 1979 · S/N 21063664 N4905RFlight Level Zero LLC · Othello, WABuilt 1975 · S/N 18802423T N49060Skylogix Aircraft LLC · La Habra, CABuilt 1979 · S/N 15283410 N4906SSweeney Peter Allan · Irvine, CABuilt 1979 · S/N R18201446 N49070Ilmberger Stephen Joseph · San Leandro, CABuilt 1977 · S/N 15281133 N49075Mccullough Nancy D · Abilene, TXBuilt 1979 · S/N 15283412 N49078Radar Aviation LLC · Mebane, NCS/N 15281137 N49079Alexander Joseph · Hamilton, INBuilt 1977 · S/N 15281138 N4907RMills Spraying Service Inc · Pahokee, FLBuilt 1975 · S/N 18802425T N4908GShaffer Aviation LLC · Tupelo, MSS/N 17273455 N4908Q1lowflyer Inc · Harrisonville, MOBuilt 1976 · S/N 18802643T N49090Victory Aviation LLC · Winchester, VABuilt 1979 · S/N 15283415 N49094Fleck Richard N Trustee · Camarillo, CABuilt 1979 · S/N 15283416 N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456 N4909YFremont Airways LLC · Riverton, WYBuilt 1980 · S/N 21064039 N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493 N49104Jprg Aviation Inc DBA · Orlando, FLS/N 15281151 N4910BCooper Ronald C · Fowlerville, MIBuilt 1979 · S/N 15283702 N4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394 N4910SMarden John E · Oakland, MEBuilt 1980 · S/N R18201449 N4911JDarter Lloyd R · Mountain Grove, MOBuilt 1981 · S/N T18803778T N49120Aviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283425 N49123Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 15281152 N49125Morey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283426 N49126Flight Expo Inc · Princeton, MNS/N 15283427 N49127Schaefer B C · Fairfield, TXS/N 15281154 N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459 N4912SStevens Joel N · Monticello, ARBuilt 1980 · S/N R18201451 N49138Osborn Scott R · Rch Palos Vrd, CABuilt 1979 · S/N 15283430 N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395 N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460 N4913JPassmore Stephen B DBA · Lacrosse, WABuilt 1981 · S/N T18803780T N49142Zion Summit Holdings LLC · Wesley Chapel, FLBuilt 1977 · S/N 15281161 N49144Westfall Benjamin C · Coeur D Alene, IDBuilt 1977 · S/N 15281163 N4914QGudgel Daniel R · Lemoore, CABuilt 1976 · S/N 18802649 N49150Skytrain Aviation LLC · Sumner, ILS/N 15281167 N49151Zhang Victoria · Daytona Beach, FLBuilt 1979 · S/N 15283432 N49159Comer Jacob W · Troy, MOBuilt 1977 · S/N 15281172 N4915PAubry Nicolas L · Port Jefferson, NYBuilt 1981 · S/N 15284840 N49161Rohan Gerard K Sr · Marion, WIBuilt 1978 · S/N 15281174 N49164Wohali Aviation LLC · Monroe, GAS/N 15281176 N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463 N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464 N49185New Horizon Aviation Inc · Warwick, RIS/N 15283435 N49189Anderson Seth A · Buckeye, AZS/N 15281182 N4918HMarks Aviation Corp · Beverly Hills, CABuilt 1979 · S/N 15284020 N4918SSilverado Sales Inc · Orem, UTBuilt 1980 · S/N R18201457

Back to AD 80-25-07 R1