Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 N921PCProppe Karl H · Needham, MABuilt 1992 · S/N 1809058 N921SJDavis Brandon Grey · Huntsville, ALBuilt 2010 · S/N 20208 N921TCBell Charles S · Fort Payne, ALS/N 23695 N921UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3566 N921WC7 Corp · Orlando, FLBuilt 1964 · S/N 2878 N921XPLengler Aviation LLC · Fort Myers, FLBuilt 1962 · S/N 1905 N922Tjk Enterprises LLC · Helena, MTBuilt 1977 · S/N 965-77 N9220DEllis Harvey Airport Inc · Guthrie, OKS/N 22-6280 N9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841030 N9221JJgms Rose LLC · Stamford, CTBuilt 1966 · S/N 28-3291 N9222DMatthews David C · Fairbanks, AKBuilt 1958 · S/N 22-6282 N9222SSvendsen James · Center Moriches, NYBuilt 1975 · S/N M-1718 N9222VSoco Scuba LLC · Austin, TXS/N 690052 N92236Garfoot William K · Verona, WIBuilt 1982 · S/N 0233 N9223FMckeeman Kevin · Abilene, KSS/N 14039C N9223HHallock Robert C III · Sag Harbor, NYBuilt 1975 · S/N 17266024 N9223JRudo Mark R · Milton, DEBuilt 1966 · S/N 28-3293 N92247World Class Aviation Ltd · Bellefontaine, OHS/N 14022C N9224JJackson Jonathan · Siloam Springs, ARBuilt 1966 · S/N 28-3294 N9224VBevington Carl R · Middle Point, OHBuilt 1969 · S/N 690053 N92255Kloker Daniel E · Owasso, OKBuilt 1973 · S/N 17261554 N9225CMeriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816447 N9226CLane Community College · Eugene, ORBuilt 1978 · S/N 28-7816448

Back to AD 79-10-03 R2