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.

N3013DMcclary Doug T · South Lyon, MIBuilt 1978 · S/N 28-7990170N3013ZZakos Dean R · Middleton, WIBuilt 1979 · S/N 28-7916395N30142Marshman Robert M · Murfreesboro, TNBuilt 1968 · S/N 17701075N30145Keno Aviation LLC · Marshfield, MAS/N 17701077N30147G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7990085N30148Tyler Marion B · Lacey, WABuilt 1968 · S/N 17701079N3014HBad Dog Aviation Inc · Meridianville, ALBuilt 1978 · S/N 28-7916182N30151Miller Jacob G · Harrison, ARFirst renewal noticeS/N 17701081N30153Waters Donovan D · Peoria, AZBuilt 1968 · S/N 17701082N30157Cardinal Aviation LLC · Pelham, NHBuilt 1968 · S/N 17701086N30158Segroves Jeffrey S · Milledgeville, GABuilt 1968 · S/N 17701087N3015DFlywell Flying Club Inc · Roseville, MNBuilt 1978 · S/N 28-7990171N3015ECuevas Ernesto · Orlando, FLBuilt 1978 · S/N 17271404N3015UCoastal Fliers Inc · El Cajon, CABuilt 1979 · S/N 28-7990335N3015ZPittman Leo B · Stanfield, AZBuilt 1959 · S/N 22-6966N30166De Jager Henry · Smithville Flats, NYBuilt 1968 · S/N 17701093N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298N30179Kowatra Anil K · Lilburn, GABuilt 1968 · S/N 17701103N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184N30182Johnson Arnold R · Mina, SDBuilt 1968 · S/N 17701105N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125N30189Onguard Aviation LLC · Cottonwood Falls, KSBuilt 1968 · S/N 17701108N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398N30195Palmer Peter L · Mission, TXBuilt 1968 · S/N 17701113N30198Thomas Mark J · Vacaville, CABuilt 1968 · S/N 17701115N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928N301AVJackson Charles A · Winchester, KYBuilt 1976 · S/N 28-7715070N301HEN301he LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2382MN301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555N301NDPutzke Becky A · Fort Ripley, MNS/N 17261763N301STTechnical Education Services Inc · Virginia Beach, VAS/N 28-25655N301TXSpitfire Aviation Inc · Wilmington, DEBuilt 1995 · S/N 1712N3020MWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 44-7995220N3020ZCapece Richard N · Leonardtown, MDS/N 22-6972N30218Mckillip Kirby G · Kemah, TXBuilt 1968 · S/N 17701127N3021CUnited States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28-7916137N3021EAircraft Solutions LLC · Spokane, WABuilt 1978 · S/N 17271405N3021HWilcox Kenneth P · Peachtree City, GABuilt 1978 · S/N 28-7990200N3021ZRichard Harold L Jr · Greencastle, PABuilt 1959 · S/N 22-6974N30222Nass Aviation Inc · Selbyville, DEBuilt 1978 · S/N 28-7990086N30225Hall Curtis B · Shepherdsville, KYBuilt 1968 · S/N 17701131N3022ZVan Helsdingen Riaan · Rapid City, SDS/N 22-6975N30230N30230 Aircraft Holdings LLC · North Charleston, SCBuilt 1978 · S/N 28-7990088N30231Pankratz Paul J · Lakeville, MNBuilt 1968 · S/N 17701136N30235Booher Harold D · Manchester, MOBuilt 1968 · S/N 17701139N30238Nunley Dwight · Hawkins, TXBuilt 1968 · S/N 17701142N30239Jones Gary E · Orange, CABuilt 1968 · S/N 17701143N3023CBlack Cloud Aviators Inc · Dubois, PABuilt 1978 · S/N 28-7990148N3023TInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-7916299
Back to AD 79-10-03 R2