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.

N9936VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264563 N9936WBrown Thrasher Aero LLC · Midland, GAS/N 28-23480 N99374Martin Douglas C · Boca Raton, FLBuilt 1965 · S/N 28-20942 N99377Barta Terry · Faribault, MNBuilt 1985 · S/N 17276439 N9937DSky High Adventures LLC · Wilmington, DES/N 18-6991 N9937E7 And 7 LLC · Leon, IABuilt 1979 · S/N 17272293 N9937QFosmo Richard E · Eatonville, WABuilt 1975 · S/N 17265881 N9937YWoods Justin S · West Glacier, MTS/N 7GCB-129 N9938DStrub Henry J Jr · Dillingham, AKBuilt 1959 · S/N 18-6993 N9938UBurton Kenneth G · Hebron, INBuilt 1977 · S/N AA5A0338 N9938WBerger Alexander W · Richmond, VAS/N 28-23482 N9938YSchneider Bros · Manning, NDBuilt 1962 · S/N 7GCB-124 N99396Flightline Air Service LLC · Pineville, LABuilt 1985 · S/N 17276441 N9939UGlover Joseph · Defuniak Springs, FLBuilt 1977 · S/N AA5A0339 N9939WHoward Dwight · Beverly Hills, FLBuilt 1967 · S/N 28-23483 N9939YGehrke Walter L · Willow Lake, SDBuilt 1962 · S/N 7GCB-140 N993CCSale Reported · Kasota, MNSale reported, pending cancellationBuilt 2000 · S/N 9910CC N993CMClaypool James W · Hunts Point, WABuilt 2014 · S/N TCQ0901055 N993DBBauer Dereck R · Springfield, ORS/N 22-6904 N993DCCoulter Daniel J · Mooresville, NCBuilt 1998 · S/N 23096 N9940VSoco Aero Leasing LLC · Santa Rosa, CABuilt 1974 · S/N 17264566 N9940WStaley Harvey Russell · Brandon, FLBuilt 1967 · S/N 28-23484 N9941DPye Jenny · Roanoke, TXBuilt 1959 · S/N 18-6997 N9941UParsons Stephen · Wellington, FLBuilt 1977 · S/N AA5A0341 N9942WMccafferty R Joseph · Winfield, MOBuilt 1967 · S/N 28-23486 N9942YHardy John R · Wasilla, AKBuilt 1962 · S/N 150 N9943ELerud Peder E · Stockton, CABuilt 1979 · S/N 17272294 N9943QGrove Todd M · Lake Stevens, WABuilt 1976 · S/N 17265887 N9943URandall Steve · Oakland, CABuilt 1977 · S/N AA5A0343 N9943YDehlin James M · Roscommon, MIBuilt 1962 · S/N 143 N9944CLarsen John E · Adrian, MIS/N S-48 N9944DRed Baron LLC · Dickinson, NDS/N 18-7013 N9944QSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265888 N9945EWilcox John C · Aurora, NEBuilt 1979 · S/N 17272295 N9945PBonner Richard A · Garrettsville, OHBuilt 1976 · S/N 18-7709011 N9945QClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 17265889 N99467Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276451 N9946QHorizon Aviation LLC · Sinclair, MEBuilt 1975 · S/N 17265890 N9946WHangar 0205 Inc · Calhoun, GABuilt 1967 · S/N 28-23491 N9947WDwinal Gary Lee · Lisbon, MEBuilt 1967 · S/N 28-23492 N9948QPemberton Addison J · Spokane, WABuilt 1954 · S/N 18-3557 N9948UDully David F W · Fernandina Beach, FLBuilt 1977 · S/N AA5A0348 N9949RJeca Flight LLC · Liberal, KSBuilt 1960 · S/N TD-388 N994CS994 Charlie Sierra Inc · Jacksonville, FLBuilt 1978 · S/N 28-7990089 N994KSEegt Inc · Helena, MTBuilt 2001 · S/N 90058 N994MBAquila Air Charter LLC · Wilmington, DEBuilt 1985 · S/N 28-8590037 N99507Alyeska Helicopters LLC · Girdwood, AKBuilt 2002 · S/N 3386 N99508Lee Randall Ross · Houston, TXBuilt 1985 · S/N 17276456 N9950DSierra Charlie Aviation LLC · Sandpoint, IDS/N 22-6738 N9950QTymitz Peter A · Eagle River, AKBuilt 1955 · S/N 18-3563

Back to AD 79-10-03 R2