AD 2012-10-13

Registered aircraft · 13,306

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

N681PGRspd-Air LLC · High Point, NCBuilt 2006 · S/N 2102N681RCObsidian Air LLC · Pompano Beach, FLS/N 402C0002N681SRegistered aircraftBuilt 2016 · S/N 4398N681SGResa Group LLC · Brunswick, GABuilt 2015 · S/N 1043N6822UKw Aircraft LLC · Judson, TXS/N 414A0808N68233Sunbird Aviation Inc · Bozeman, MTBuilt 1981 · S/N 340A1273N68236Vaughn Air LLC · Hillsboro, ORBuilt 1981 · S/N 340A1275N68239Northeast Skywagon LLC · Pittsfield, MEBuilt 1981 · S/N 340A1276N6823DS A Fliers LLC · Venice, FLBuilt 1980 · S/N 340A1042N6823FTreetop Aviation LLC · Wilson, NCBuilt 1980 · S/N 340A1043N68245Registration Pending · Anderson, SCRegistration pendingBuilt 1980 · S/N 340A1204N6824LEnvironmental Evolutions Transportation Inc · Robstown, TXBuilt 1980 · S/N 340A1201N6825TSongbird Aviation LLC · Larkspur, CABuilt 1981 · S/N 340A1208N6826BDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1978 · S/N 21062840N6826LThomas Faulhaber Pc · La Veta, COBuilt 1980 · S/N 340A1213N6826QBeechcraft Heritage Museum · Tullahoma, TNBuilt 1964 · S/N D-7450N6827LDuke Aviation LLC · Woodridge, ILBuilt 1980 · S/N 340A1219N6828PSnowfox Insurance Inc · Pace, FLBuilt 1981 · S/N 340A1226N6828RDaves Aircraft LLC · Eden, NCBuilt 1981 · S/N 340A1227N6829WGroupe Caraibe LLC · Wilmington, DEBuilt 1984 · S/N EA-407N682CDFly Tlc LLC · Dexter, MOBuilt 2006 · S/N 1790N682JDWindward Air LLC · Orlando, FLBuilt 1981 · S/N 414A0802N682JSIflyhigh LLC · Phoenix, AZBuilt 1981 · S/N 340A1237N682RMHuebel Ross · Houston, TXBuilt 2007 · S/N 2577N682SRMajdalani Maher J · Perrysburg, OHBuilt 2007 · S/N 2691N682VCCotham Victor S · Saint John, INBuilt 2022 · S/N 3RX139N6830LN661w Air LLC · Dalton, GABuilt 1980 · S/N 310R2102N6830WRocket Airways LLC · Verona, WIBuilt 2023 · S/N 9237N6834APlum Family Buildings LLC · Marengo, IABuilt 1984 · S/N EA-408N68379Express Carrier LLC · St Thomas, VIBuilt 1981 · S/N 402C0469N6838XOcean Flight Corp · Weston, FLBuilt 1978 · S/N 402B1346N68391Hyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0483N6839RGolden Wings LLC · Tampa, FLBuilt 2002 · S/N 0405N6839YRichland Aviation Inc · Sidney, MTBuilt 1981 · S/N 402C0481N683DMMcmorphy LLC · Erie, PABuilt 2009 · S/N 3427N683SDMurray Steven L · Webster, NYBuilt 1980 · S/N EA-148N683SRTf Global LLC · Houston, TXBuilt 2007 · S/N 2766N683TM007 Arkansas Aviation LLC · Jonesboro, ARBuilt 1979 · S/N 414A0237N6846CDillon T34 6846c LLC · Scottsdale, AZS/N CCF34-58N684BCRegistered aircraftBuilt 2005 · S/N 1295N684CABrown Luke · Center, TXBuilt 2026 · S/N 11229N684CDFreedom Development Corporation LLC · Matthews, NCS/N 1786N684DMMidwest Aviation Equipment LLC · Solon, IABuilt 2019 · S/N 4774N684LGGold Aircraft Leasing LLC · Fort Lauderdale, FLBuilt 2022 · S/N 8705N684SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1969 · S/N 20700147N684SRPelair LLC · Milton, DEBuilt 2007 · S/N 2816N6850BJennings Donald J · Gypsum, COS/N 21062845N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255N685CDGraves Koene R Trustee · Paso Robles, CABuilt 2006 · S/N 1768N685CPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 310R-1375
Back to AD 2012-10-13