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.

N80670Jb Aviation Management Inc · Wonder Lake, ILBuilt 1976 · S/N 17266697 N80673Mitchell Aviation LLC · Mitchell, SDBuilt 1976 · S/N 17266698 N80678Aero Maintenance Inc · Vancouver, WABuilt 1976 · S/N 17266699 N8067GMaley Randy J · New Philadelphia, OHBuilt 1971 · S/N 177RG0067 N8068GStructural Design And Analysis Inc · Reston, VABuilt 1971 · S/N 177RG0068 N80690Flight Foundation · Unicoi, TNBuilt 1981 · S/N 15285367 N80692Registered aircraftBuilt 1976 · S/N 17266703 N80697Moe-Air LLC · Cincinnati, OHBuilt 1976 · S/N 17266705 N806CInternational Divers Co Inc · Corpus Christi, TXBuilt 2010 · S/N 1100-2010 N806DAPeak Leasing LLC · Anchorage, AKBuilt 1977 · S/N 17270154 N806HAFlywell Aviation LLC · Bowling Green, KYBuilt 1976 · S/N 17266669 N80700Changes In Latitude LLC · Kingwood, TXBuilt 1976 · S/N 17266706 N8071GBell John · Queen Creek, AZBuilt 1971 · S/N 177RG0071 N80725High Flight Academy LLC · Allison Park, PAS/N 17266716 N80729Poon Tsui P · Rosemead, CABuilt 1976 · S/N 17266719 N80734Tipps Robert J Jr · Port Aransas, TXBuilt 1976 · S/N 17266721 N80735S & S Aircraft Inc · El Dorado, ARFirst renewal noticeBuilt 1976 · S/N 17266722 N8073EOcean Aviation Inc · Berlin, MDBuilt 1978 · S/N 17272129 N8073GBaker Brenten E · Farmington Hills, MIBuilt 1971 · S/N 177RG0073 N80742Elliott Richard D · Castle Rock, WABuilt 1976 · S/N 17266726 N8074EN8074e LLC · Jackson, NJS/N 17272130 N8074GBudge Ross Spencer · Colorado Springs, COS/N 177RG0074 N80751Haaland Karlyle R · Dalhart, TXBuilt 1976 · S/N 17266728 N80759Leaseair LLC · Wilmington, DES/N 17266733 N8075GVaughns Flying Service Inc · Reese, MIBuilt 1973 · S/N 18801226T N80764Mcneill Jim R · Wichita, KSBuilt 1976 · S/N 17266735 N80767Ainsworth Martha Trustee · Bowie, MDBuilt 1976 · S/N 17266737 N8076GGriffin Billy J · Corona, CABuilt 1971 · S/N 177RG0076 N80773Boyl Traci L · Ukiah, CABuilt 1976 · S/N 17266740 N80774Dugger Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 17266741 N8077ESws Aviation Services Inc · Titusville, FLBuilt 1978 · S/N 17272133 N8077GPhillips Stuart · La Conner, WABuilt 1971 · S/N 177RG0077 N80781P D H S Aerial Photography Inc · Spicewood, TXBuilt 1976 · S/N 17266745 N80784Stamm David A · Lake Almanor, CAS/N 17266747 N80788Bell Aa Flying Club Inc · Mechanicsburg, PABuilt 1976 · S/N 17266748 N8078G615dm LLC · Hazel Green, ALBuilt 1971 · S/N 177RG0078 N80790Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17266749 N80797Neitz Frank · Bethel, AKS/N 17266750 N80798Thomas Dean Properties LLC · O Fallon, MOBuilt 1976 · S/N 17266751 N8079GBoney Grady · Rhine, GABuilt 1973 · S/N 18801227T N807HDTubbs Jerry M · Manns Harbor, NCBuilt 1976 · S/N 17266730 N80800West Bend Air Inc · West Bend, WIBuilt 1976 · S/N 17266752 N80803Bradley Charles S · East Bethel, MNS/N 17266754 N80807Wings Over Texas Holdings LLC · Denton, TXS/N 17266755 N80810White Hawk Aviation Inc · Brandy Station, VABuilt 1976 · S/N 17266757 N80816Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1976 · S/N 17266760 N8082EAviation Access LLC · Van Nuys, CABuilt 1978 · S/N 17272135 N80830Mahnattan Flying Tigers Inc · Bozeman, MTBuilt 1976 · S/N 17266764 N80837Lucky Richard E · Skipperville, ALBuilt 1976 · S/N 17266767 N80841Sparta 140 Club Inc · Grand Rapids, MIBuilt 1976 · S/N 17266769

Back to AD 80-25-07 R1