OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N7305JMallozzi Anthony M · Norwalk, CTBuilt 1968 · S/N 28-24636N73063Oregon State Flying Club · Corvallis, ORBuilt 1976 · S/N 17267256N73068Christensen Gary D · Alliance, NEFirst renewal noticeBuilt 1976 · S/N 17267259N73069Eagle Sky Patrol Inc · Deadwood, SDBuilt 1976 · S/N 17267260N7306DJ S H Farms Inc · Hermiston, ORBuilt 1957 · S/N 22-5093N7306EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272081N7306FMeans James · Burleson, TXS/N 28-25219N7306KKutschera Thomas C · Youngsville, NYBuilt 1950 · S/N 20-216N7307DKnight Todd A · Grimes, IAS/N 22-5095N7307FEllis Johnathan · Evansville, WYS/N 28-25220N7307JAlmonte Duran Arquimedes · Paterson, NJBuilt 1968 · S/N 28-24640N7308CChandler Air Service Inc · Chandler, AZBuilt 1975 · S/N 28-7625075N7308GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259008N7308JMacdermaid Harry R · Kenai, AKFirst renewal noticeBuilt 1968 · S/N 28-24616N73091Rudder33 LLC · Grantham, NHBuilt 1976 · S/N 17267261N73093Yngsdal Dale A · Lino Lakes, MNBuilt 1976 · S/N 17267262N7309CKeefer Ralph E · Markle, INBuilt 1975 · S/N 28-7615051N7309KStanley Bryan D · Paso Robles, CABuilt 1950 · S/N 20-218N730ACHeimbach Paul A · Steamboat Springs, COBuilt 1999 · S/N 1277-99N730BRHagan David W · Overgaard, AZBuilt 2002 · S/N 3554N730HAHonaker Group LLC · Sellersburg, INS/N 17267246N730LBEarly Bird Aviation LLC · Rillito, AZBuilt 1974 · S/N 17263162N730LKBay Aero Ventures LLC · Port Clinton, OHBuilt 1977 · S/N 28-7890070N730UOhio University · Albany, OHBuilt 2005 · S/N 2842224N73103Bfl Aviation LLC · Bakersfield, CABuilt 1976 · S/N 17267267N73105Jlk Management LLC · Kerrville, TXBuilt 1976 · S/N 17267268N7310CC3 Aircraft LLC · Burnet, TXBuilt 1975 · S/N 28-7690066N7310GMccall Freddie W Jr · East Brewton, ALBuilt 1970 · S/N 17259010N73113Top Flight Aviation Inc · Corona, CABuilt 1976 · S/N 17267269N73116Taildraggers Flyers Inc · Saint Joseph, MIBuilt 1976 · S/N 17267272N7311DRasmussen Kent L · Jetmore, KSBuilt 1957 · S/N 22-5099N7311FRegistered aircraftBuilt 1968 · S/N 28-25225N7311JBouley John T · Tolland, CTFirst renewal noticeBuilt 1968 · S/N 28-24658N7312DJenkins James L · Lake Stevens, WABuilt 1957 · S/N 22-5100N73131Fremont Flight Academy LLC · Fremont, OHBuilt 1976 · S/N 17267280N73134Harborside Aviation Services Inc · Punta Gorda, FLBuilt 1976 · S/N 17267281N73146Oregon State Flying Club Inc · Corvallis, ORBuilt 1976 · S/N 17267287N73148Kinney Transportation · Columbia, MOBuilt 1976 · S/N 17267289N73149Good Flight Aviation LLC · Stockton, CABuilt 1976 · S/N 17267290N7314FAero Vantage Aviation Services LLC · Bayonne, NJBuilt 1968 · S/N 28-25272N7314GKittle Aviation LLC · Wichita, KSBuilt 1970 · S/N 17259014N7314WWelch Tully D · Brackettville, TXBuilt 1963 · S/N 28-1177N73151Hawaii Aviators LLC · Ewa Beach, HIBuilt 1976 · S/N 17267292N73154Bishop Services LLC · Ellisville, MSBuilt 1976 · S/N 17267293N7315DSkyhaven Airport Inc · Tunkhannock, PABuilt 1957 · S/N 22-5103N7316GCox Capital LLC · Rushville, MOS/N 17259016N7316WCallaboo LLC · Greenwood, SCBuilt 1963 · S/N 28-1180N73170Jahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17267297N73171Jettmar Rainer U · Washington, DCBuilt 1976 · S/N 17267298N73172American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267299
Back to AD 80-04-03 R2