OpenAirDocs.org
AD 85-03-04 R2

Registered aircraft · 340

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:85-03-04-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:85-03-04-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.

N112MGTalley Miriam S · San Antonio, TXBuilt 1973 · S/N 42N112RCStraubel Investments Inc · Egg Harbor, WIBuilt 1973 · S/N 79N112SJSuchomel Chase E · North Saint Paul, MNS/N 38N112WNEvans William M · Nipomo, CABuilt 1974 · S/N 169N1137JDaugusta Richard J · Lexington, MAS/N 137N1140JGardner John D · Tallahassee, FLBuilt 1974 · S/N 140N1143JDurrah Anthony E Sr · Charlotte, NCBuilt 1974 · S/N 143N1144JLee Carl B · Bullard, TXBuilt 1974 · S/N 186N1145JPrestridge Austin · Newark, OHBuilt 1974 · S/N 145N1147JSandel Henry Adrian III · Natchez, MSBuilt 1974 · S/N 132N114ANHake Scott W · Swoope, VABuilt 1978 · S/N 14396N114AWCameron Hugh R · Gainesboro, TNBuilt 1976 · S/N 14095N114BLLoose David C · Blanco, TXBuilt 1976 · S/N 14003N114BMJaswal Faisal · La Conner, WABuilt 1976 · S/N 14082N114BTMidnight Black International LLC · Helena, MTS/N 14221N114CTTairex Inc · Wilmington, DES/N 14413N114DFNorthwoods Distribution Services Inc · Rhinelander, WIBuilt 1978 · S/N 14360N114DWLayman Nathan L · Hudson, WIBuilt 1978 · S/N 14408N114EEEngstrom Eric R · Eastover, NCBuilt 1978 · S/N 14357N114FFCoastal Development Group LLC · Boca Grande, FLBuilt 1976 · S/N 14012N114GTEnders Richard A · San Bernardino, CABuilt 1976 · S/N 14130N114HHHuddleston H Glenn · San Antonio, TXS/N 14209N114HPDolanair LLC · Coal Valley, ILBuilt 1978 · S/N 14370N114JAWright Richard D · Acworth, GABuilt 1978 · S/N 14365N114JTVanbeek Donald Eugene · Tualatin, ORBuilt 1976 · S/N 14104N114KLKaruppannan Venkatachalam · Troy, MIBuilt 1978 · S/N 14427N114LWAmes Thomas E · Yuma, AZBuilt 1977 · S/N 14275N114MBCrew Andrew P · Chester, CTBuilt 1976 · S/N 14084N114MDUrsic Albert J · Minden, NVS/N 14033N114MGW F Carter Construction Inc · Arlington, TXBuilt 1978 · S/N 14382N114MMSchwabenbauer Theodore J · Diamond Bar, CAS/N 14380N114MTSattig Henry B II · Cortez, COBuilt 1976 · S/N 14068N114PBBernabucci Christian J · Mapleton, NDBuilt 1976 · S/N 14057N114RCAsbury William A · Bridger, MTBuilt 1976 · S/N 14011N114RWLaw C Scott · Oklahoma City, OKBuilt 1976 · S/N 14048N114SDPremier Property LLC · Elkin, NCS/N 14264N114SEHigh Flight Aviation LLC · Charlotte, NCS/N 14027N114SJMeashey Matthew · Wake Forest, NCBuilt 1977 · S/N 14318N114SLSimply Living LLC · Fort Myers, FLS/N 122N114SMColvin Daniel A · Dayton, TNBuilt 1978 · S/N 14442N114SRSkymaster Stc LLC · Mena, ARS/N 14016N114SSHeritage Air LLC · Scappoose, ORS/N 14291N114TBWelch D Michael · Foster City, CABuilt 1976 · S/N 14172N114TCIntegritas Forum LLC · Sundance, WYBuilt 1978 · S/N 14355N114USPeters Richard A · San Marino, CABuilt 1978 · S/N 14386N114WCMahan Dusty · Cookeville, TNBuilt 1976 · S/N 14126N1151JRescue Evangelical Church · Fitchburg, MABuilt 1974 · S/N 151N1156JTeam Omega Multimedia Ohio LLC · Blacklick, OHBuilt 1974 · S/N 156N115JWFeric Drazen · Mesa, AZBuilt 1976 · S/N 14081N1160JSchreiber William E II · Edgar, WIBuilt 1973 · S/N 125
Back to AD 85-03-04 R2