Skip to content

Registered aircraft · 25,369

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.

N80842Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266770 N80847Evergreen Flying Club Inc · Medina, WABuilt 1976 · S/N 17266771 N8084BN8084b LLC · Fort Worth, TXBuilt 1975 · S/N 177RG0705 N80855Bowe Joseph E DBA · Chippewa Falls, WIBuilt 1976 · S/N 17266774 N8085EMcdonald Douglas A · Falls Church, VAS/N 17272137 N80864Kessler Garry A · Lansing, WVBuilt 1976 · S/N 17266778 N80865Green Rick A · Hudson, IABuilt 1976 · S/N 17266779 N80866Preston Richard K Trustee · Albuquerque, NMBuilt 1976 · S/N 17266780 N80868Paradis Paul A · Bar Harbor, MEBuilt 1976 · S/N 17266781 N80870Robben William J · Pampa, TXBuilt 1976 · S/N 17266782 N80871Monnin Aviation LLC · Amherst, NYBuilt 1976 · S/N 17266783 N80872Yakima 872 Flying Club · Yakima, WABuilt 1976 · S/N 17266784 N80874Jls Aviation LLC · Fredericksburg, VABuilt 1976 · S/N 17266786 N80884Rein W Clark · Ottawa, KSBuilt 1976 · S/N 17266788 N80896Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17266793 N8089ESkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 17272138 N8089GWellman Steven R Trustee · Englewood, FLBuilt 1971 · S/N 177RG0089 N808DMRhoads Timothy C · Logan, NMS/N 18268443 N808UFMahoney Clinton D · Tecumseh, NEBuilt 1975 · S/N 17264869 N80906Red Door Aviation LLC · Dover, DEBuilt 1976 · S/N 17266796 N80912Bay Area Concrete LLC · Hayward, CABuilt 1976 · S/N 17266798 N80914Cp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 17266799 N8091EChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172-75486 N8091GWood Kim W · Tucson, AZBuilt 1971 · S/N 177RG0091 N80921Conerly Group LLC · Denham Springs, LABuilt 1976 · S/N 17266803 N80928Bellingham Aviation Services LLC · Bellingham, WABuilt 1976 · S/N 17266804 N80931Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266806 N80941Holombo Ray J · Taylors, SCBuilt 1976 · S/N 17266810 N8094GTri Rotor Spray & Chemical · Ulysses, KSBuilt 1973 · S/N 18801230 N80952Registered aircraftBuilt 1976 · S/N 17266817 N80959Mets Flying Club Inc · Fairmount, INBuilt 1976 · S/N 17266819 N80961A S Air LLC · Lantana, FLBuilt 1976 · S/N 17266820 N80975N80975 LLC · Wilmington, DEBuilt 1976 · S/N 17266821 N80982Reiselt Paul T F · Corinth, MSBuilt 1976 · S/N 17266825 N80985Mullins James C · Franklin, TNBuilt 1976 · S/N 17266826 N80991Flowers Robert Clyde III · Manchaca, TXBuilt 1976 · S/N 17266830 N80996Halley Dan R · Avery, TXBuilt 1976 · S/N 17266832 N809BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267437 N809STDiaz Natanael Luna · Toa Baja, PRS/N 17268873 N80AMGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1980 · S/N 0829 N80BDJtr Aviation LLC · Canton, TXBuilt 1980 · S/N 613-80 N80DLJetstream Aeronautics LLC · San Antonio, TXBuilt 1979 · S/N 15283230 N80FPCarastro Enterprises LLC · Montgomery, ALBuilt 1978 · S/N 17271343 N80JVBaker Aviation Consulting LLC · Summerland Key, FLBuilt 2015 · S/N 1207 N80SDLake Area Technical College · Watertown, SDBuilt 2005 · S/N 1397-2007 N80SGFerland Henry L III · Vidalia, GABuilt 1980 · S/N 21064014 N80TARegistration Pending · Lancaster, CARegistration pendingS/N 632-80 N810CLMathews Roy E · Sparta, MIBuilt 1970 · S/N 17259162 N810FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272297 N810JLFly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17274975

Back to AD 80-25-07 R1