AD 2012-06-01

Registered aircraft · 726

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-06-01')
    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-06-01')
  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.

N840JSFe 5282 LLC · Kinston, NCBuilt 2002 · S/N 560-5282N841DWSouth Coast Aviation Inc · Portland, ORBuilt 2001 · S/N 560-5177N841JSFe Xl 5253 LLC · Kinston, NCBuilt 2002 · S/N 560-5253N842AAstec Industries Inc · Chattanooga, TNBuilt 1999 · S/N 560-5042N843JSFe Encore Plus II LLC · Kinston, NCBuilt 2003 · S/N 560-5343N844JSFe5344 LLC · Kinston, NCBuilt 2003 · S/N 560-5344N845JSThese Pretzels Are Making Me Thirsty LLC · Kinston, NCBuilt 2001 · S/N 560-5180N846JSChinaberry Landing LLC · Sugar Hill, GABuilt 2003 · S/N 560-5355N847A8m Holdings LLC · Bloomfield, NEBuilt 1999 · S/N 560-5047N847JSJml Jet II LLC · Uvalde, TXBuilt 2003 · S/N 560-5320N850FTHuff Air LLC · Uvalde, TXS/N 560-5807N851JSFe Xl 5111 LLC · Kinston, NCBuilt 2000 · S/N 560-5111N852JSFe Xls 5566 LLC · Kinston, NCBuilt 2005 · S/N 560-5566N852LHKriskraft Air LLC · Orange, CABuilt 2013 · S/N 560-6160N853FCFoote Aviation LLC · Manhattan, KSBuilt 2016 · S/N 560-6211N853JSFe Encore Plus I LLC · Kinston, NCBuilt 2003 · S/N 560-5352N854ANYonderbyrd LLC · Hickory, NCBuilt 2007 · S/N 560-5713N855ACVision Jet LLC · Fort Wayne, INBuilt 2007 · S/N 560-5720N855JSFe 5064 LLC · Kinston, NCBuilt 2000 · S/N 560-5064N855SCStarlight Flights Aviation LLC · Wolfforth, TXBuilt 2008 · S/N 560-5763N856JSFe 5040 LLC · Kinston, NCBuilt 1999 · S/N 560-5040N857CBSpm3 LLC · Phoenix, AZBuilt 2019 · S/N 560-6278N857JSFe 5608 LLC · Kinston, NCBuilt 2006 · S/N 560-5608N859FTMf Equipment LLC · Uvalde, TXBuilt 2004 · S/N 560-5528N85HAEb Aircraft LLC · Elkhart, INBuilt 2015 · S/N 560-6183N860JST&E Aviation LLC · Albuquerque, NMBuilt 2001 · S/N 560-5154N860MWampatuck Aviation LLC · Marshfield, MABuilt 2019 · S/N 560-6283N863JSFe 5512 LLC · Kinston, NCBuilt 2004 · S/N 560-5512N864JSJk Air LLC · Fayetteville, ARS/N 560-5242N865JSFe 5283 LLC · Kinston, NCBuilt 2002 · S/N 560-5283N865TNUniversity Of Tennessee · Knoxville, TNBuilt 2009 · S/N 560-6038N865UTUniversity Of Tennessee · Alcoa, TNBuilt 2004 · S/N 560-5517N867JSJs Jet III LLC · Kinston, NCBuilt 2002 · S/N 560-5292N867WKendall Hunt Publishing Co Inc · Dubuque, IABuilt 2006 · S/N 560-5601N868CGIrg Wings LLC · Los Angeles, CABuilt 2010 · S/N 560-6077N868CMRegistered aircraftBuilt 2021 · S/N 560-6316N868JSEverything Aviation LLC · Trabuco Canyon, CABuilt 2001 · S/N 560-5152N868XLWhiskey Delta Bravo LLC · Fort Myers, FLBuilt 2005 · S/N 560-5603N869JSExclusive Jets LLC · Kinston, NCBuilt 2001 · S/N 560-5159N86WUUmphrey Air LLC · Beaumont, TXBuilt 2001 · S/N 560-5198N8701LCitation Oil & Gas Corp · Houston, TXBuilt 2007 · S/N 560-5751N870JSFe Xls 6200 LLC · Kinston, NCBuilt 2015 · S/N 560-6200N871RFScheels All Sports Inc · Fargo, NDBuilt 2001 · S/N 560-5219N872BBStampede Aviation LLC · Phoenix, AZBuilt 2004 · S/N 560-5515N872JSSea Jay LLC · Raleigh, NCBuilt 2002 · S/N 560-5302N876ADRegistered aircraftBuilt 2017 · S/N 560-6240N876RAParminter Investments LLC · Wilmington, DEBuilt 2002 · S/N 560-5231N876UCRegistered aircraftBuilt 2006 · S/N 560-5652N877RWRed Wing Shoe Company Inc · Red Wing, MNBuilt 2012 · S/N 560-6123N87BEOrion Aviation LLC · Jeffersonville, INBuilt 2011 · S/N 560-6087
Back to AD 2012-06-01