OpenAirDocs.org
AD 2010-06-12 R1

Registered aircraft · 79

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

N503TSCox Aviation LLC · Portsmouth, RIBuilt 2007 · S/N 42.AC103N506SKFlight Stars Az LLC · Tempe, AZBuilt 2007 · S/N 42.AC092N508PAAlpha Leasing LLC · Daytona Beach, FLBuilt 2007 · S/N 42.AC079N56KDDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2007 · S/N 42.AC076N607PADolphin Leasing LLC · Daytona Beach, FLBuilt 2007 · S/N 42.AC078N614ZMTwin 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.AC016N68MJSky 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.091N712PMBogosh 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.AC101N825TDTremik LLC · Conroe, TXBuilt 2007 · S/N 42.AC098N888UBS R Liner LLC · Canton, MABuilt 2006 · S/N 42.AC004N892MADragonfly Aviation LLC · Winder, GABuilt 2008 · S/N 42.AC122N906ERHeavy Metal Air LLC · Farmingdale, NYBuilt 2007 · S/N 42.301N919ABVolume Millwork Mfg LLC · Houston, TXS/N 42.AC107N931PAFlight Stars Az LLC · Tempe, AZBuilt 2008 · S/N 42.AC131N935PASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 42.AC125N93YTGoli Aviation LLC · Raleigh, NCBuilt 2007 · S/N 42.AC093N961JBGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2006 · S/N 42.089N987TSN777yy LLC · Opa Locka, FLBuilt 2007 · S/N 42.AC088
Back to AD 2010-06-12 R1