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.

N99045Allen Michael R · Graham, NCBuilt 1985 · S/N 17276396 N99048Bradley Aircraft Co · Columbus, INBuilt 1976 · S/N 17268367 N9904QStanford Jay J · Saint Marys, GABuilt 1975 · S/N 17265848 N9904VStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17264553 N9905QCentral Air Service · Lewistown, MTBuilt 1975 · S/N 17265849 N9906LRiseaero LLC · Florence, SCBuilt 1986 · S/N 17276647 N9906TRausch Henry J · Harpers Ferry, WVBuilt 1978 · S/N 38-78A0237 N9907CBlue Marlin LLC · Kalispell, MTBuilt 1978 · S/N R18200488 N9907QPlasco Designs Of Arkansas Inc · Texarkana, ARBuilt 1975 · S/N 17265851 N9908HKoch Vincent Karl · Canyon Lake, CABuilt 1981 · S/N 18268104 N9909ESmith C Gary · Gretna, LABuilt 1982 · S/N 24-1346 N9909NMorgan Vernon E · Dillon, COS/N 21063250 N9909QCk Aviation LLC · Charlestown, INBuilt 1975 · S/N 17265853 N990ASMccoy Darren T · Caledonia, MIS/N 680167 N990BFlight Academy LLC · Van Nuys, CABuilt 1978 · S/N 17272059 N990BCMclaughlin Philip · Bakersfield, CABuilt 2006 · S/N 487-2006 N990DGRichmeier Patrick R · Quinter, KSBuilt 1967 · S/N 670039 N990GGoebel Greg D · Petaluma, CABuilt 2002 · S/N 893-2002 N990JDPaoli Sylvia L · La Mirada, CABuilt 1965 · S/N 655 N990SAOn-Site Aviation Inc · Hillsboro, NDBuilt 1974 · S/N 31-74 N990WYAmelia Reid Aviation LLC · San Jose, CABuilt 1976 · S/N 1168-76 N99100Sterling Flight Training LLC · Jacksonville, FLBuilt 1985 · S/N 172-76401 N99104Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276403 N9910QTevebaugh Dennis J · Elkhart, KSBuilt 1975 · S/N 17265854 N9911QAeronautical Technical Service Inc · Collierville, TNS/N 17265855 N9912LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276648 N9912QKd Aviation LLC · Sheridan, WYBuilt 1975 · S/N 17265856 N9912TLang Robert H · Pittsburgh, PABuilt 1978 · S/N 38-78A0241 N99141Airgo Inc · Centralia, ILBuilt 1985 · S/N 17276409 N9914ESimica Charles A · Marietta, GABuilt 1979 · S/N 17272288 N9914LFlex Air Holdings Inc · Manhattan, KSBuilt 1986 · S/N 17276649 N9914QVictor Aviators Inc · Kernersville, NCBuilt 1975 · S/N 17265858 N99157Hess Garrett J · Fullerton, CABuilt 1985 · S/N 17276412 N9915BTaro Investment LLC · Doral, FLBuilt 1982 · S/N 172RG1078 N9915TRobinson Christopher Cody · Richmond, KYBuilt 1978 · S/N 38-78A0245 N9916TRogers Greg · Las Vegas, NVBuilt 1978 · S/N 38-78A0246 N99171Airlake Aero Inc · Lakeville, MNBuilt 1985 · S/N 17276414 N9917QStill Flying LLC · Gibsland, LABuilt 1975 · S/N 17265861 N9918EByrne Evan A · Mountain Lake Park, MDBuilt 1979 · S/N 17272289 N9918GRoettger Investment Corporation · Evansville, INBuilt 1981 · S/N 24-1093 N9918QCerqueira Luiz Fernando · Orem, UTBuilt 1975 · S/N 17265862 N9919BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 172RG1080 N9919QBlomstrom Andrew R · Oregon, WIBuilt 1975 · S/N 17265863 N991BCHusby Jeffrey L · Eau Claire, WIBuilt 2024 · S/N 1215-2024 N9920BSchultz Robert G · Baker, FLBuilt 1982 · S/N 172RG1081 N9920VSkywarrior Flight Training Inc · Pensacola, FLBuilt 1974 · S/N 17264556 N9922YInfinite Wings LLC · Henderson, NVBuilt 1982 · S/N 21064640 N9923YPostupack Peter Jr · New Cumberland, PABuilt 1982 · S/N 21064641 N99243Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276418 N9924BNatre Air II LLC · Tipton, INBuilt 1982 · S/N 172RG1082

Back to AD 80-25-07 R1