Skip to content

Registered aircraft · 25,367

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.

N13286Aero Club Seven Inc · Crosslake, MNBuilt 1973 · S/N 17262640 N13287Armstrong Aviation Services LLC · Freeport, PABuilt 1973 · S/N 17262641 N1328ESj28e LLC · Durango, COBuilt 1978 · S/N 17270958 N1328UMetildi Frederic H · Penfield, NYBuilt 1976 · S/N 17267016 N13293Atp Aircraft 2 LLC · Wilmington, DEBuilt 1973 · S/N 17262644 N13294Cmb Aviation Inc · Surf City, NCBuilt 1973 · S/N 17262645 N13295Johnson Thomas C Jr · Adrian, MIBuilt 1973 · S/N 17262646 N13296T31 Fliers LLC · Prosper, TXBuilt 1973 · S/N 17262647 N1329QGodlove Gary L · Glendale, AZBuilt 1973 · S/N 17262642 N1329UA C W Inc · Gonzales, LABuilt 1982 · S/N 21064687 N1329WKasowski Frank Jr · Becker, MNBuilt 1963 · S/N 217 N132ACScott John A · Odebolt, IABuilt 1992 · S/N 675-92 N132DPKarl Mark G · Wilbraham, MABuilt 1999 · S/N 822-99 N132HMMichels Agribusiness Inc · Plentywood, MTBuilt 1978 · S/N R18200844 N132PAAumont Eric J · Yucca Valley, CABuilt 1998 · S/N 817-98 N132PCWebbco LLC · Riverview, FLBuilt 1978 · S/N 24-0541 N132PJPierson Ted · Gooding, IDBuilt 2007 · S/N 496-2007 N132SMBartholet John C · Columbus, GABuilt 1973 · S/N 17702045 N13301Iowa Lakes Community College · Estherville, IAS/N 17262649 N13305Harbin Michael Wade · Monahans, TXBuilt 1976 · S/N 17702409 N13307Burden Richard M Trustee · Woodway, TXBuilt 1976 · S/N 17702410 N1330WPepke Mark · Memphis, TNBuilt 1963 · S/N 218 N13314Egan Richard G · Tallahassee, FLBuilt 1976 · S/N 17702412 N13319Messenger Jonathan M · Baker, MTBuilt 1973 · S/N 17262665 N13320Zeytounian Nazareth · Weatherford, TXBuilt 1973 · S/N 17262666 N13323Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 17262668 N13327Rodriguez Richard · Indianapolis, INBuilt 1973 · S/N 17262672 N1332WRegistered aircraftBuilt 1963 · S/N 220 N13330Shulthise Arthur J III · Hardinsburg, KYBuilt 1973 · S/N 17262674 N13333Wooding William W · Anacortes, WAS/N 17262677 N13334Tlb Inc · Howell, NJS/N 17262678 N13337High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262681 N1333MJil Aviation Inc · La Coste, TXBuilt 1972 · S/N 17260573 N1333PJones Robert Conrad · Seeley Lake, MTBuilt 1979 · S/N R18200875 N1333UKellogg Larry L · Tonganoxie, KSBuilt 1976 · S/N 17267020 N1333WJamieson Robert A · Titusville, FLBuilt 1963 · S/N 221 N13342Aog Hawaii LLC · Paia, HIBuilt 1976 · S/N 17702414 N13346Stafford Cessna 13346 An LLC · Lafayette, LABuilt 1973 · S/N 17262688 N1334WTwo Way Communications LLC · Graham, TXBuilt 1963 · S/N 222 N13353Irwin Kenneth F · Byron, ILBuilt 1973 · S/N 17262692 N13356Burns Jerry D · Baraboo, WIBuilt 1973 · S/N 17262694 N13358Nfh Aviation LLC · Pikeville, KYBuilt 1973 · S/N 17262696 N1335WCastanon Salvador L · Rancho Cucamonga, CABuilt 1963 · S/N 223 N13362Edwards Samuel T · Mustang, OKBuilt 1976 · S/N 17702415 N13364Cornerstone Aircraft Sales Inc · Wonder Lake, ILBuilt 1973 · S/N 17262702 N13365Pacific Flight Academy LLC · Honolulu, HIBuilt 1973 · S/N 17262703 N13366Tracy Shannon C · Fort Mill, SCS/N 17262704 N13367Hartline Alan G · Benton Harbor, MIBuilt 1973 · S/N 17262705 N1336UA & F Aviation Services LLC · Collierville, TNBuilt 1976 · S/N 17267021 N1336WThree Six Whiskey LLC · Billings, MTS/N 224

Back to AD 80-25-07 R1