OpenAirDocs.org
AD 76-23-02

Registered aircraft · 186

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:76-23-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-23-02')
  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.

N114ANHake 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 14318N114SMColvin 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 14126N115JWFeric Drazen · Mesa, AZBuilt 1976 · S/N 14081N116RCMiesch Gary D · Gowen, MIBuilt 1976 · S/N 14061N127XYLaap LLC · Clancy, MTBuilt 1976 · S/N 14039N12XGCommander Aviation LLC · Williamsburg, VABuilt 1977 · S/N 14237N1322Temple Donald G · Colorado Springs, COBuilt 1976 · S/N 14165N136DBuckeye Ridge Farm LLC · Vidalia, GABuilt 1978 · S/N 14361N14SGBorts Gerald S · Altadena, CABuilt 1978 · S/N 14434N166DAAnca Aircraft LLC · Fort Myers, FLBuilt 1976 · S/N 14166N1907JDaedal Flight LLC · Lancaster, SCBuilt 1976 · S/N 14007N1920JDerrick James E · Godley, TXBuilt 1976 · S/N 14020N192DBTodd Tracy · Lancaster, SCBuilt 1976 · S/N 14021N1931JAerodyme Corp · South Burlington, VTBuilt 1976 · S/N 14031N1934JN1934j LLC · Highland Lakes, NJBuilt 1976 · S/N 14025N1937JBryant Joe Henry Jr · Meridian, MSBuilt 1976 · S/N 14037N1938JCsi Asset Management Inc · Naples, FLBuilt 1976 · S/N 14036
Back to AD 76-23-02