OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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
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.

N27TXDavis David A · Weatherford, TXBuilt 1969 · S/N 195N27VVEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1972 · S/N 001N27WKWillkris Aviation Services LLC · Smithfield, VABuilt 1972 · S/N 250-72N28003Jensen Larry R · Palo Alto, CABuilt 1978 · S/N AA5B0935N28006Hellwig Frederic C · Nevada City, CABuilt 1978 · S/N AA5B0938N2800WAzul Aviation Inc · Fort Worth, TXS/N 1029N2800ZRitchie John A Jr · Gold Hill, NCBuilt 1959 · S/N 22-6793N2801EJ4 Aero LLC · Gulf Breeze, FLBuilt 1978 · S/N 17271327N2801PVistad Bruce W · Fergus Falls, MNS/N 008N2801XJones Daniel L · Newton, ALBuilt 1967 · S/N 17700201N2801ZValiair Limited Company Trustee · Casper, WYBuilt 1959 · S/N 22-6794N2802TRandolph Clint · Bullhead City, AZBuilt 1972 · S/N 28R-7235134N2802ZPeavler Christopher · Modoc, SCS/N 22-6795N2803PLewis Stephen R · Chillicothe, ILBuilt 1955 · S/N 22-3095N2803TBarron David L · Sun City, AZBuilt 1972 · S/N 28-7225241N2803XStamper Douglas H · Norfolk, VABuilt 1967 · S/N 17700203N2804MEhrenborg Robert J · Fisherville, KYBuilt 1977 · S/N 28-7890269N2804ZWatson Jennifer R · San Jose, CABuilt 1978 · S/N 371-78N2805QA L Hollandsworth LLC · Columbia, MOBuilt 1971 · S/N 17259805N2806EBexar Aviation LLC · San Antonio, TXBuilt 1978 · S/N 17271328N2806MCondor Aero Club Inc · Zelienople, PABuilt 1977 · S/N 28-7890270N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806N2806TN2806t Leasing Company LLC · Mason, MIBuilt 1972 · S/N 28-7205223N2807EMission One LLC · Excelsior, MNBuilt 1978 · S/N 17271329N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807N2808PValiair Limited Co Trustee · Casper, WYBuilt 1955 · S/N 22-3101N2808UCoastal Flight Inc · Half Moon Bay, CAS/N 1056N2809PDavis Gerald R · Hernando Beach, FLS/N 22-3102N2809XGuckian Jim J · Riverdale, GABuilt 1967 · S/N 17700209N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498N280MAMcgarity Daniel Scott · Essex, MOBuilt 2004 · S/N 4552004N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230N280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 11070CN280SEKennicott Wilderness Air LLC · Boonton, NJBuilt 1954 · S/N 18-3803N280TCNobles Gary D · Fairview, TXS/N 28-21227N280YSCrabtree Martin L · Sedalia, MOS/N BING-1N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137N2811WRegistered aircraftAssigned, pending cancellationS/N TD-66N2811ZHill Daniel A · Soldotna, AKBuilt 1959 · S/N 22-6804N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212N2812ZRubbert Randy C · Reynolds, NDS/N 22-6805N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813N2813TKamper Gregory S · Ripon, CABuilt 1972 · S/N 28-7225237N2814MBruggeman Michael J · Saint Paul, MNBuilt 1946 · S/N 12-1182N2814ZGibney Paul H · Palmer, MABuilt 1959 · S/N 22-6807N2815FKlopping William E · Apple Valley, CAS/N 28-7916438N2815PJohnson Trevor T · Somerset, WIBuilt 1955 · S/N 22-3108
Back to AD 79-10-03 R2