AD 2019-03-13

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:2019-03-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:2019-03-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.

N650DHDrury Development Corp · Saint Louis, MOBuilt 2008 · S/N 247N651DHDrury Development Corp · Saint Louis, MOBuilt 2015 · S/N 319N668TVentu Aviation LLC · Tampa, FLBuilt 2008 · S/N 276N674PGArthur J Gallagher (Illinois) LLC · Rolling Meadows, ILBuilt 2011 · S/N 296N67KPMarivest Support Services LLC · Pittsburg, KSBuilt 2008 · S/N 249N68HHoward Industries Inc · Laurel, MSBuilt 2011 · S/N 297N696FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 202N700FAJet Flight LLC · Shreveport, LABuilt 2008 · S/N 278N705AKFamily Tree Farms Aviation LLC · Dinuba, CABuilt 2007 · S/N 221N719KXKnight Air LLC · Phoenix, AZS/N 275N730GAG150-Sn302 LLC · Cincinnati, OHBuilt 2012 · S/N 302N777FLAgnes LLC · Ashland, ORBuilt 2006 · S/N 214N802RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 263N813HDSwcf Holdings LLC · Tampa, FLBuilt 2008 · S/N 264N819AMSiddons Martin Aviation LLC · Houston, TXBuilt 2008 · S/N 272N850KRRichair Investments LLC · North Little Rock, ARBuilt 2007 · S/N 232N876GHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 298N8821CJvwl LLC · Woodland, CABuilt 2007 · S/N 226N888Ajenat Holdings LLC · Washington, DCBuilt 2006 · S/N 207N901SSTwo Star Maritime LLC · Fremont, CABuilt 2008 · S/N 254N922LRCapital Holdings 210 LLC · Newark, DEBuilt 2011 · S/N 299N927AGArthur J Gallagher (Illinois) LLC · Rolling Meadows, ILBuilt 2007 · S/N 236N927CJPhase 4 Aviation LLC · Miami, FLBuilt 2015 · S/N 317N92TBSilver Diamond LLC · Dallas, TXBuilt 2008 · S/N 271N935GBSchneider National Inc · Green Bay, WIBuilt 2010 · S/N 293N963CHBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 316N96ADAltair Advanced Industries Inc · Bellingham, WABuilt 2008 · S/N 246N990MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 242N9MMTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2007 · S/N 225
Back to AD 2019-03-13