AD 2011-11-07

Registered aircraft · 114

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

N430TSWateractive43 LLC · Auburn, CABuilt 2006 · S/N 42.AC030N435TSMidwest Corporate Air Inc · Bellefontaine, OHS/N 42.AC035N442SRErdman Aviation LLC · Mather, CABuilt 2006 · S/N 42.120N449DSDelta State University · Cleveland, MSBuilt 2011 · S/N 42.AC141N449TSDiamond Flight LLC · Portland, ORBuilt 2007 · S/N 42.AC049N457TSK2 Aviation LLC · Greenwood Village, COBuilt 2007 · S/N 42.AC062N458TSPaine Albert J Jr · Daniels, WVBuilt 2007 · S/N 42.AC058N459TSUtah State University · Logan, UTBuilt 2007 · S/N 42.AC059N460LDTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2007 · S/N 42.AC066N460TSGraham Aviation LLC · Belgrade, MTBuilt 2007 · S/N 42.AC060N461PANichols Aviation LLC · Seattle, WABuilt 2007 · S/N 42.AC087N461THIndiana State University · Terre Haute, INBuilt 2007 · S/N 42.AC044N465ASSequoia Insight LLC · Houston, TXFirst renewal noticeBuilt 2007 · S/N 42.AC065N469WWMx Jets Inc Trustee · Carson City, NVBuilt 2007 · S/N 42.AC074N471HPMidwest Corp Air Inc · Bellefontaine, OHBuilt 2006 · S/N 42.138N480TSAnodyne Of Savannah LLC · Newark, DEBuilt 2007 · S/N 42.AC080N483TSDouble Diamond Aviation LLC · Greenbrier, TNBuilt 2007 · S/N 42.AC083N485AGDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2007 · S/N 42.AC085N48DSEydon LLC · Boca Grande, FLBuilt 2007 · S/N 42.AC070N490AGFxe Flightcenter Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 42.112N490TSVories Dennis L Pe · College Place, WABuilt 2007 · S/N 42.AC090N491TSCarter Stephen S Trustee · Rancho Santa Fe, CABuilt 2007 · S/N 42.AC091N496TSDiamond 777 LLC · Chestnut Ridge, NYBuilt 2007 · S/N 42.AC096N499BKAero Leasing Inc · Redding, CABuilt 2007 · S/N 42.AC099N49TTTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2006 · S/N 42.AC010N503TSCox Aviation LLC · Portsmouth, RIBuilt 2007 · S/N 42.AC103N506SKFlight Stars Az LLC · Tempe, AZBuilt 2007 · S/N 42.AC092N56KDDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2007 · S/N 42.AC076N591ERDiamond Aircraft Sales U S A Inc · London OntarioNon-citizen corporation, flight hours not reportedBuilt 2006 · S/N 42.081N594ERFive Star Marketing Inc · Raleigh, NCBuilt 2007 · S/N 42.AC064N59LUPhoenix42 LLC · Meridian, IDBuilt 2009 · S/N 42.AC148N610ASOrtega Aviation Services LLC · Wichita, KSBuilt 2009 · S/N 42.AC143N614ZMTwin Eagles Aviation LLC · High Point, NCBuilt 2007 · S/N 42.AC113N622GGDa42 LLC · Waterville, MEBuilt 2006 · S/N 42.AC023N629SAMalone Air Holding LLC · Jacksonville, FLBuilt 2006 · S/N 42.AC011N638AKFlyshure LLC · Minneapolis, MNBuilt 2006 · S/N 42.146N648KMValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 42.316N652TGeebee Ventures LLC · Belgrade, MTS/N 42.AC026N660LDDiamond 777 LLC · Spring Valley, NYBuilt 2006 · S/N 42.AC016N687MLJettech Consulting LLC · Houston, TXBuilt 2007 · S/N 42.AC069N68MJSky Warrior Flight Training LLC · Pensacola, FLBuilt 2007 · S/N 42.AC063N702RFNovember Tango LLC · Richmond, VABuilt 2007 · S/N 42.AC109N704ABMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2006 · S/N 42.091N712MMBuzzfamilyair LLC · Spring, TXBuilt 2007 · S/N 42.302N712PMBogosh David P · Irvine, CABuilt 2006 · S/N 42.AC009N718CAKappner Alexander · Las Vegas, NVBuilt 2007 · S/N 42.AC110N742SAFacory Omar · Bakersfield, CABuilt 2007 · S/N 42.AC112N801KCNulton Enterprises LLC · Johnstown, PABuilt 2007 · S/N 42.AC101N822SAPughs Air West LLC · Carlsbad, CABuilt 2006 · S/N 42.AC006N825TDTremik LLC · Conroe, TXBuilt 2007 · S/N 42.AC098
Back to AD 2011-11-07