OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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

N3010ZClemente Matthew J · Troy, NYBuilt 1959 · S/N 22-6961N30112Leonard Kevin J · Wagner, SDBuilt 1968 · S/N 17701066N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076N30116Registration Pending · Benson, AZRegistration pendingBuilt 1968 · S/N 17701068N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077N3011FGordon Air Services Inc · Miami, FLBuilt 1974 · S/N 17263447N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084N30128Mizani Air LLC · San Antonio, TXBuilt 1968 · S/N 17701069N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112N3012DArias Herman R · Waco, GAS/N 28-7916154N3012EDamschroder Rex A · Fremont, OHBuilt 1978 · S/N 17271402N3012ZChase 13 LLC · Wilmington, DEBuilt 1959 · S/N 22-6963N30133Ts Fliers LLC · Mount Pleasant, MIBuilt 1968 · S/N 17701070N30139Heinitz Bradford C · Arlington, WAS/N 17701074N3013DMcclary 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-7995220
Back to AD 80-04-03 R2