AD 2012-13-12

Registered aircraft · 1,192

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-13-12')
    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-13-12')
  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.

N316FSea To Sea Aviation LLC · Dallas, TXBuilt 2003 · S/N 5007N316GNGeneral Industries LLC · Camden, NJBuilt 2012 · S/N 5389N316VAAvation LLC · Grand Rapids, MIBuilt 2015 · S/N 5530N316VBLiving Word Christian Center · Forest Park, ILBuilt 1999 · S/N 1377N318DCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 4229N319CRKangaruby LLC · Wilmington, DEBuilt 2009 · S/N 5260N319FSBanc Of California · Chicago, ILBuilt 2020 · S/N 5621N319STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5114N31BGGsbg Asset Holdings LLC · Atlanta, GABuilt 2011 · S/N 4243N31GVAircraft Fidelity Corp Trustee · Dover, DEBuilt 1988 · S/N 1084N320JMBlaise Carolina LLC · Wilmington, DEBuilt 2005 · S/N 4035N321SDN321sd Inc · Melbourne, FLBuilt 2013 · S/N 5420N323MKMkre Equipment LLC · Coral Gables, FLBuilt 2007 · S/N 4077N324FPWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 1475N325CTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5401N325HQSunset Harbour Consulting LLC · Miami Beach, FLBuilt 2012 · S/N 5391N327TLThomas H Lee Capital LLC · Teterboro, NJBuilt 1998 · S/N 1339N329GAGulfstream Aerospace Corp · Savannah, GABuilt 1998 · S/N 1329N329HFHr Leasing LLC · Dover, DEBuilt 2007 · S/N 4108N32JEKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 1460N32TMJmt II LLC · Glenview, ILS/N 4196N33055Maybach Air LLC · Davie, FLBuilt 2012 · S/N 5407N330RWWest2east 330 LLC · Seattle, WABuilt 2000 · S/N 1382N332GAGulfstream Aerospace Corp · Savannah, GABuilt 1998 · S/N 1332N332PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5283N333DSAdc Holdings LLC · Manteca, CABuilt 2010 · S/N 5292N333ECFlying Falcon Inc · Frenchmans Bay Qtr, VIBuilt 2001 · S/N 1414N333EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5220N333FGFg Aviation LLC · Philadelphia, PABuilt 1999 · S/N 1364N336EBJ C Flowers & Co LLC · New York, NYBuilt 2015 · S/N 5525N336LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2000 · S/N 5081N337LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2007 · S/N 5099N338LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2000 · S/N 5150N338MMRegistered aircraftBuilt 1988 · S/N 1076N339ETTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4295N339JMHd Landing LLC · Dover, DEBuilt 2007 · S/N 5178N339LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2007 · S/N 5166N33LVMd Air LLC · Wilmington, DEBuilt 2014 · S/N 4316N340FLHines Hill Aviation LLC · Boston Heights, OHBuilt 2000 · S/N 612N344AAAbsolutamente LLC · Windsor, CABuilt 1992 · S/N 1186N344RSU S Bank Na Trustee · Hartford, CTBuilt 2013 · S/N 5444N345LCN276gc LLC · Carlsbad, CABuilt 2007 · S/N 5145N348DJMecha Holdings LLC · Newtown Square, PABuilt 1998 · S/N 1348N34HSHs Arrow LLC · Indianapolis, INBuilt 2015 · S/N 5514N350GDGulfstream Leasing LLC · Savannah, GABuilt 2005 · S/N 4023N352BHGle 1393 LLC · Sunny Isles, FLBuilt 1999 · S/N 1393N352DJDelawair LLC · Newark, DEBuilt 1998 · S/N 1352N352FT352 Corp · Conshohocken, PABuilt 2000 · S/N 1420N353LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5519N35AAFalcon Landing LLC · Hawthorne, CABuilt 2011 · S/N 5291
Back to AD 2012-13-12