Registered aircraft · 40,471

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-04-03-R2') 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-04-03-R2') 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-04-03-R2')
    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-04-03-R2')
  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-04-03-R2')
  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-04-03-R2')
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.

N9208SFrush Charles A · Burlington, NJBuilt 1975 · S/N M-1688 N9209QMckeeman Trevor T · Manhattan, KSBuilt 1990 · S/N 14009C N920ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841216 N920AJAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263234 N920BTThorpe Brian J · Saint Augustine, FLBuilt 2002 · S/N 1041 N920CJJones Alva L · Craig, COBuilt 1960 · S/N 56 N920ERSunrise Aviation · Ormond Beach, FLBuilt 1993 · S/N 4495013 N920GBales Don · Oakhurst, CABuilt 1981 · S/N 172RG0901 N920GTBeauchesne Harold J · Enterprise, ALBuilt 1978 · S/N AA5B0920 N920HGGreco Robert J · Overgaard, AZS/N M-II-586 N920HWWikstad Herulf L · Nevada City, CABuilt 1998 · S/N 920 N920LHHatley Byron J · Sparks, NVBuilt 2024 · S/N 01 N920PHYetiskin Kenan · Huntsville, ALBuilt 1976 · S/N 28-7615390 N92103Pgd Flyers Inc · Cape Coral, FLBuilt 1973 · S/N 17261545 N9210HFlex Air Holdings Inc · Wilmington, DEBuilt 1975 · S/N 17266017 N9210MHahn David · Port Lavaca, TXBuilt 1991 · S/N 11067C N9211JBrown Herbert R · Halls, TNBuilt 1966 · S/N 28-3280 N9211MSowers James Dalton · Park City, KYBuilt 1966 · S/N 3435 N9211VMorrissey Thomas A · Peachtree City, GABuilt 1969 · S/N 690047 N9212JJones Greg E · Thomasville, GABuilt 1966 · S/N 28-3281 N92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYBuilt 1973 · S/N 17261546 N9213JRegistered aircraftBuilt 1966 · S/N 28-3283 N9213KCarver Clarence K · Lutz, FLBuilt 1976 · S/N 28-7625170 N9213YCarty Eric · Anchorage, AKBuilt 1971 · S/N 18-8918 N92141High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17261549 N9214JSale Reported · Hurdsfield, NDSale reported, pending cancellationBuilt 1966 · S/N 28-3284 N9214SC&L Aviation LLC · New London, WIBuilt 1975 · S/N M-1737 N9214VGostomski Michael J · Yacolt, WABuilt 1969 · S/N 690049 N92159Buster Aviation LLC · Harveys Lake, PABuilt 1973 · S/N 17261550 N9215JGrizzard Shawn C · Hayden, IDS/N 28-3285 N92161Skywarrior Flight Training Inc · Pensacola, FLBuilt 1973 · S/N 17261551 N92169Welch William Ben · Danville, ILBuilt 1973 · S/N 17261553 N9216DBlackbird Aviation LLC · Bedford, PABuilt 1958 · S/N 22-6276 N9216HBurgess Alan P · Corona, CABuilt 1975 · S/N 17266020 N9216JSantana Alexandre C · Long Beach, CABuilt 1966 · S/N 28-3286 N9217DBischoff Danielle I · Palmer, AKBuilt 1958 · S/N 22-6277 N9217JWaicekauskas Joe · Raymondville, MOBuilt 1966 · S/N 28-3287 N9217KR & R Air Inc · Wilmington, DEBuilt 1976 · S/N 28-7615183 N9217MMullenbach Arnold D · Tucson, AZBuilt 1966 · S/N 3438 N9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1988 · S/N 2841022 N9218DMaestas Jonathan M · Wright City, MOBuilt 1958 · S/N 22-6278 N9218RFishe Flying Corp · Vero Beach, FLBuilt 1988 · S/N 2841023 N9218VTerrell Aviation Inc · Terrell, TXBuilt 1969 · S/N 690051 N9219HKful Flyers Foundation Inc · Fullerton, CABuilt 1975 · S/N 17266021 N9219KJones Robert M · Brooksville, FLBuilt 1976 · S/N 28-7690229 N921AARegistration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 17261752 N921DCCarlson Donald A III · Lexington, TNBuilt 1975 · S/N AA5B-0039 N921JKShackleford Wayne D · Riverside, CABuilt 1982 · S/N 921-80 N921KCRocket City Helicopters LLC · Brownsboro, ALBuilt 1992 · S/N 2180 N921LCCrum Robert W · Lake Havasu City, AZBuilt 1969 · S/N 28-25939

Back to AD 80-04-03 R2