AD 2012-17-05

Registered aircraft · 1,197

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-17-05')
    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-17-05')
  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.

N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545N312LGJet Masters LLC · Englewood, COBuilt 1982 · S/N 489N312STexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1999 · S/N 258436N314CGN314cg Aviation LLC · Saint Louis, MOBuilt 2006 · S/N 258781N314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 133N314SJHrm Aviation LLC · Chesterfield, MOBuilt 1992 · S/N 115N314TCTop Cat Aviation LLC · Pelham, ALBuilt 1999 · S/N 258400N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480N316CLCalco 316 LLC · Frisco, TXBuilt 1993 · S/N 6507032N316MFMf Property Management LLC · Hattiesburg, MSS/N 258314N316TDBas Part Sales LLC · Greeley, COBuilt 1980 · S/N 312N3170BSpring Mountain Enterprises Inc · Corvallis, ORS/N 650-0136N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532N317TTInter Island Yachts Inc · Zephyr Cove, NVBuilt 1980 · S/N 317N318NWMed Jets USA Inc · Boca Raton, FLBuilt 1980 · S/N 318N31GJGlobal Jetcare Inc · Brooksville, FLBuilt 1976 · S/N 022N31KHAery Aviation LLC · Wilmington, DEBuilt 1999 · S/N 173N31LJDelta November LLC · Lewes, DEBuilt 1994 · S/N 097N31RARoyal Air Freight Inc · Waterford, MIBuilt 1979 · S/N 288N31YAInternational Trading Energy Fuels LLC · Houston, TXBuilt 1990 · S/N 021N31ZVEzair International Leasing And Management Inc · Wilmington, DEBuilt 1996 · S/N 127N31ZZE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N NA0437N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523N320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 366N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515N321VAValiair Limited Co Trustee · Casper, WYBuilt 1997 · S/N 650-7077N322GC1mg LLC · Fort Wayne, INBuilt 1990 · S/N 142N322PRN322pr LLC · Scottsdale, AZBuilt 1991 · S/N 038N323AAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258155N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325N325JFN325jf Operating LLC · Dallas, TXBuilt 1990 · S/N 6500181N325NWKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 325N325RDLow Tide LLC · Riverside, IABuilt 1995 · S/N 650-7056N327GALmi LLC · Alpharetta, GABuilt 2005 · S/N 157N327MPSimsco LLC · Houston, TXBuilt 2011 · S/N HB-72N328JLLamon Aviation LLC · Boise, IDBuilt 1996 · S/N 157N328PCSn 328 Corp · Fort Lauderdale, FLS/N 328N329TJForsythe Aviation LLC · Point Lookout, MOS/N 120N32HMAir Mellon LLC · Wilmington, DEBuilt 1983 · S/N 499N32KBS S K Hawker Group LLC · New Haven, CTBuilt 2000 · S/N 258461N331JVBoulder Falcon LLC · Salt Lake City, UTS/N 219N331SKD & E Aviation LLC · Missoula, MTBuilt 1992 · S/N 063N331USN331us LLC · Hillsboro, ORBuilt 2000 · S/N 196N333DLD&S Aircraft LLC · Chicago, ILBuilt 1997 · S/N 163N333KEFalconmitch Inc · Sulphur Springs, TXBuilt 1974 · S/N 14N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669N335KBShelt William J · Denton, TXS/N 588N335PRGy Aircraft LLC · Daytona Beach, FLBuilt 1989 · S/N 647N335RCN335 Aviation Corp · Middletown, DEBuilt 1979 · S/N 256N33612Pmdg Flight Operations LLC · Alexandria, VABuilt 1989 · S/N 196
Back to AD 2012-17-05