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.

N307DLNova Jets USA Corp · Orlando, FLS/N 2002N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665N308GWWilliams Marketing Services Inc · Carthage, MOBuilt 2010 · S/N HA-0157N30AXN27ax LLC · Tulsa, OKBuilt 2001 · S/N 141N30HQLearjet Inc · Wichita, KSBuilt 1999 · S/N 045N310LJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 031N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314N311KBJet Plaid LLC · Nashville, TNBuilt 2004 · S/N 135N311RSKen Sale Resources Inc · Southlake, TXBuilt 1977 · S/N 5222N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545N312SHRegistered aircraftBuilt 2011 · S/N 251N313ZPLigon Air LLC · Birmingham, ALBuilt 2008 · S/N HA0064N314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 133N315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 315N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480N316CJNovember 316 LLC · Caldwell, WVBuilt 2008 · S/N 359N316CLCalco 316 LLC · Frisco, TXBuilt 1993 · S/N 6507032N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532N317MCMgl Equipment LLC · Omaha, NEBuilt 2008 · S/N 380N31KHAery Aviation LLC · Wilmington, DEBuilt 1999 · S/N 173N31YAInternational Trading Energy Fuels LLC · Houston, TXBuilt 1990 · S/N 021N31ZVEzair International Leasing And Management Inc · Wilmington, DEBuilt 1996 · S/N 127N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523N321AJM Hixson Aviation LLC · Denton, TXBuilt 2000 · S/N 77N321AKSnails Pace Aviation LLC · New York, NYBuilt 2008 · S/N 222N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515N322BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 363N322FJRegistered aircraftBuilt 2020 · S/N 322N325BMjnsln LLC · Minnetonka, MNBuilt 2008 · S/N 370N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325N325PTCentennial Breeze LLC · Colleyville, TXBuilt 2008 · S/N 387N326KHGator One Air LLC · Destin, FLBuilt 2007 · S/N 230N327GALmi LLC · Alpharetta, GABuilt 2005 · S/N 157N3285NDodson International Parts Inc · Rantoul, KSS/N HA-0045N328JLLamon Aviation LLC · Boise, IDBuilt 1996 · S/N 157N32AASmolyanov Aviation Holdings LLC · Waterford, MIBuilt 2009 · S/N 399N330GWDonart LLC · Needham, MABuilt 2007 · S/N HA0003N331JVBoulder Falcon LLC · Salt Lake City, UTS/N 219N331USN331us LLC · Hillsboro, ORBuilt 2000 · S/N 196N333DLD&S Aircraft LLC · Chicago, ILBuilt 1997 · S/N 163N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669N33612Pmdg Flight Operations LLC · Alexandria, VABuilt 1989 · S/N 196N337CCChapman Corp · Washington, PABuilt 2009 · S/N HA-0155N3386ABcma LLC · Belleville, MIBuilt 2008 · S/N HA0056N340SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 2043N341AEConquest Express LLC · Libertyville, ILBuilt 2012 · S/N 2132N341HBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 341N343WTPhantom Phlyers LLC · Pearland, TXBuilt 1986 · S/N 633911N345GCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 2121N349JFBlue Jay 1 LLC · Fort Worth, TXBuilt 2007 · S/N HA-0012
Back to AD 2012-16-14