AD 2011-22-01

Registered aircraft · 1,167

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:2011-22-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-22-01')
  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.

N507VJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2011 · S/N 9446N508CKIbc Hospitality LLC · Newport Beach, CABuilt 2007 · S/N 5158N50JEIn50je LLC · New York, NYBuilt 1999 · S/N 567N50KUUnder The Stars LLC · Millington, TNBuilt 2001 · S/N 659N50SRegistered aircraftBuilt 2008 · S/N 5216N50VCBoulder Haven LLC · Dallas, TXBuilt 2013 · S/N 9539N50WHWhite Wing Holdings LLC · Waukegan, ILBuilt 2019 · S/N 5589N510GTSouthwest Associates LLC · Bigfork, MTBuilt 2008 · S/N 5204N510GVTtp Services LLC · Hillsborough, NCBuilt 2006 · S/N 5106N510QSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5326N510SRRelated 2019 LLC · New York, NYBuilt 2017 · S/N 6282N511DBSkybird Aviation Inc · Newport Beach, CABuilt 2013 · S/N 6058N513DLPnc Financial Services Group Inc · Pittsburgh, PABuilt 2017 · S/N 9786N513MARichport Air LLC · Miami, FLBuilt 2003 · S/N 5019N513TFEac Air LLC · New York, NYBuilt 2012 · S/N 9508N514NBAlten Consulting LLC · Fort Lauderdale, FLBuilt 2020 · S/N 60036N515KAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 6028N515MJFleet Two LLC · Beverly Hills, CABuilt 2025 · S/N 60177N516GHMadero Air LLC · South Saint Paul, MNBuilt 1998 · S/N 553N516WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5516N517DWColleen Corp · New Castle, DEBuilt 2013 · S/N 5417N517TWGtw Corp · Jupiter, FLBuilt 2008 · S/N 5209N518DDDcs Aviation LLC · Dallas, TXBuilt 2004 · S/N 9141N518GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5618N518GPG550 Msn 5051 Leasing LLC · Miami Beach, FLBuilt 2004 · S/N 5051N519CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 9200N51SETps LLC · Medina, WABuilt 2004 · S/N 9138N51VETrousdale Aviation LLC · West Hollywood, CABuilt 1999 · S/N 586N521GAGulfstream Aerospace Corp · Savannah, GABuilt 1997 · S/N 521N521SBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 5199N522GDL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5622N524ACPegasus Leasing LLC · Ada, MIBuilt 2013 · S/N 5433N524AGTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 686N524VEBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5424N526EMEmi Travel LLC · Tampa, FLBuilt 2016 · S/N 5537N526GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5626N526SDWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5229N527GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5627N527JGGibbs International Inc · Spartanburg, SCBuilt 2005 · S/N 5067N528APArrow Plane Lc · Provo, UTBuilt 2007 · S/N 5168N528MPCr Holdings LLC · Crystal Lake, ILBuilt 2008 · S/N 9307N529GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2021 · S/N 5629N529RLRegistered aircraftBuilt 1999 · S/N 574N530GL3harris Technologies Flight Capital LLC Trustee · Greenville, TXBuilt 2021 · S/N 5630N530KCRegistered aircraftBuilt 2006 · S/N 9206N530PMEbts LLC · New York, NYBuilt 2004 · S/N 5031N531GAL3harris Technologies Flight Capital LLC Trustee · Greenville, TXBuilt 2021 · S/N 5631N532SPGulfstream Leasing LLC · Savannah, GAFirst renewal noticeBuilt 2001 · S/N 632N533GVWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 5330N535VDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1997 · S/N 535
Back to AD 2011-22-01