OpenAirDocs.org
AD 2010-14-21

Registered aircraft · 35

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-14-21')
    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-14-21')
  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.

N101DAFlying High Again LLC · Mount Juliet, TNBuilt 2006 · S/N 42.125N119BJFlight Stars Az LLC · Tempe, AZBuilt 2007 · S/N 42.AC045N132TSUtah State University · Logan, UTBuilt 2006 · S/N 42.AC018N149WTVectors To Final LLC · Columbus, OHBuilt 2007 · S/N 42.AC046N16FAAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2007 · S/N 42.AC029N189YCerrit LLC · Helena, MTBuilt 2006 · S/N 42.AC033N197TSTango Charlie Foxtrot LLC · Port Orange, FLBuilt 2006 · S/N 42.AC001N198TSWorld Class Aviation Ltd · Bellefontaine, OHBuilt 2006 · S/N 42.AC002N199TSWind Rising Ventures LLC · Columbus, MSBuilt 2006 · S/N 42.AC003N213WJDiamond N213wj Inc · Coral Gables, FLS/N 42.AC053N215BNMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 42.AC055N242DPFlying High Again LLC · Mount Juliet, TNBuilt 2006 · S/N 42.AC032N243TSJoerithan & Mp Aviation LLC · Whittier, CABuilt 2007 · S/N 42.AC043N316MZBecerra George C · Northridge, CABuilt 2007 · S/N 42.AC054N327TSTransport Services LLC · Little Rock, ARBuilt 2006 · S/N 42.AC027N328TSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2006 · S/N 42.AC028N35ALTriple M Aviation Inc Trustee · Wilmington, DEBuilt 2006 · S/N 42.147N415TSBeta Fleet LLC · South Burlington, VTBuilt 2006 · S/N 42.AC015N424RPFlight Stars Az LLC · Mesa, AZBuilt 2007 · S/N 42.AC039N430TSWateractive43 LLC · Auburn, CABuilt 2006 · S/N 42.AC030N435TSMidwest Corporate Air Inc · Bellefontaine, OHS/N 42.AC035N449TSDiamond Flight LLC · Portland, ORBuilt 2007 · S/N 42.AC049N458TSPaine Albert J Jr · Daniels, WVBuilt 2007 · S/N 42.AC058N459TSUtah State University · Logan, UTBuilt 2007 · S/N 42.AC059N460TSGraham Aviation LLC · Belgrade, MTBuilt 2007 · S/N 42.AC060N49TTTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2006 · S/N 42.AC010N622GGDa42 LLC · Waterville, MEBuilt 2006 · S/N 42.AC023N629SAMalone Air Holding LLC · Jacksonville, FLBuilt 2006 · S/N 42.AC011N652TGeebee 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.AC063N704ABMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2006 · S/N 42.091N712PMBogosh David P · Irvine, CABuilt 2006 · S/N 42.AC009N888UBS R Liner LLC · Canton, MABuilt 2006 · S/N 42.AC004N961JBGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2006 · S/N 42.089
Back to AD 2010-14-21