AD 2012-16-14

Registered aircraft · 779

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

N426SASuperior Ambulance Aviation Inc · Elmhurst, ILBuilt 2011 · S/N 426N428CJNo Res LLC · Scottsdale, AZBuilt 2008 · S/N 256N428DRMaverick Air II LLC · Deer Park, WABuilt 2005 · S/N 154N428JDDewberry Air LLC · Atlanta, GABuilt 2006 · S/N 210N42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 258509N42NFCest La Vie LLC · Piedmont, OKBuilt 1997 · S/N 12N42NHEagle Wings Capital LLC · Ponte Vedra Beach, FLS/N HA-0006N431JDBlue Pearl Aviation LLC · Saint Louis, MOBuilt 2009 · S/N HA-0117N4343FFrenkel Tardis Development Corp LLC · Dallas, TXBuilt 2003 · S/N 258641N435DCGuardian Flight LLC · Lewisville, TXBuilt 2004 · S/N 249N435HHBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 335N438RVAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 2007 · S/N 333N43MFMed Flight Air Ambulance Inc · Albuquerque, NMBuilt 1980 · S/N 284N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628N440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 85N440JACreamer Pilot Services LLC · Fayetteville, ARBuilt 2006 · S/N 2044N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524N441QCBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N HA-0067N442FPNord Aviation LLC · Lone Tree, COBuilt 2008 · S/N 364N445FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 455N445NAirblue Eagle Inc · Houston, TXBuilt 2002 · S/N 202N445TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 443N445WFScarmardo Cattle Company LLC · Caldwell, TXBuilt 2006 · S/N 299N449BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 274N44LGHarborjet LLC · Petoskey, MIBuilt 2009 · S/N 2125N44MBTria Entertainment LLC · Wisconsin Dells, WIBuilt 2002 · S/N 258573N44VPGable S Corp · West Linn, ORBuilt 2002 · S/N 115N450FCN450fc LLC · Nashville, TNBuilt 2011 · S/N 416N450TJJaco Oil Co · Bakersfield, CABuilt 1998 · S/N 012N451SDFortune Aviation LLC · Longview, TXBuilt 2010 · S/N 411N451SJTexas Mna LLC · Westlake, TXBuilt 2001 · S/N 173N452CFHangar LLC · Las Vegas, NVBuilt 1982 · S/N 104N452CKKalitta Charters LLC · Ypsilanti, MIBuilt 2000 · S/N 105N452LJLearjet Inc · Wichita, KSExpired dealerBuilt 1995 · S/N 002N452MPMed Air LLC · Lawrenceville, GABuilt 2001 · S/N 152N452SDJet Quest LLC · Hunting Valley, OHBuilt 2011 · S/N 428N453AMN543am LLC · Englewood, COBuilt 1982 · S/N 453N454LCColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2011 · S/N 419N454MFCpc Aviation LLC · Bellaire, TXBuilt 2002 · S/N 201N454NBelle Air Leasing LLC · Wilmington, DEBuilt 2007 · S/N 339N455DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 129N455RCSolomon Mark Trustee · Wilmington, DEBuilt 1998 · S/N 096N456GSRueter Leasing LLC · Grand Junction, IABuilt 2002 · S/N 225N45HFBoard Of Regents Of The Univ Of Nebraska · Lincoln, NES/N 121N45HGAsphalt Materials Inc · Indianapolis, INBuilt 2007 · S/N 343N45HKWalmart Inc · Bentonville, ARBuilt 2007 · S/N 349N45JACreamer Pilot Services LLC · Fayetteville, ARBuilt 2008 · S/N 385N45JGLearjet 45 LLC · Sellersburg, INBuilt 2005 · S/N 272N45JHSped Air LLC · Nashville, TNBuilt 2010 · S/N 397N45KHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 313
Back to AD 2012-16-14