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.

N5524Avpro Inc · Annapolis, MDS/N 5524N552HADepartment Of Defense Missile Defense Agency · Tulsa, OKBuilt 2010 · S/N 5288N552MWSchweitzer Aircraft Leasing Inc · Pullman, WABuilt 2020 · S/N 5615N552SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 5625N552YMWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 9511N553GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 5053N553HADepartment Of Defense Missile Defense Agency · Tulsa, OKBuilt 2010 · S/N 5290N553RBG550 LLC · Reno, NVBuilt 2004 · S/N 5056N553SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5575N554AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9492N554DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5196N554SNTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 5604N555GATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6334N555HDDkh Services LLC · Salt Lake City, UTS/N 9328N555KHRegian Services LLC · Encino, CABuilt 2009 · S/N 5237N555PVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9841N5569Landmark Graphics Corp · Houston, TXBuilt 2007 · S/N 5169N557ADGulfstream Flight Holdings LLC · New York, NYS/N 6329N5585Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5085N559DWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5110N559GGlen Alba Investments Inc Trustee · Wilmington, DEBuilt 2003 · S/N 5012N55BMJet Force V LLC · Fresno, CABuilt 1999 · S/N 560N55FVIsh Flight LLC · Bloomfield Hills, MIBuilt 1997 · S/N 533N55GVTc Business Aviation LLC · San Francisco, CABuilt 1997 · S/N 515N55QCQuikrete Aircraft Leasing LLC · Atlanta, GABuilt 2014 · S/N 5495N560UCsms Management LLC · Pearland, TXBuilt 2009 · S/N 9366N5616Geev LLC · Cartersville, GABuilt 2000 · S/N 616N561RLAgile Equipment Leasing LLC · Wilmington, DEBuilt 2004 · S/N 9139N561SKJet Air Management LLC · Miami Beach, FLBuilt 2015 · S/N 5529N562THGlobal One Tjh LLC · San Antonio, TXBuilt 2001 · S/N 9085N563BBGulfstream V 563 LLC · Midland, TXBuilt 1998 · S/N 563N565JCBank Of Utah Trustee · Salt Lake City, UTS/N 699N565JMNational Oceanic And Atomospheric Administration · Lakeland, FLBuilt 2016 · S/N 5538N565JTBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 525N566PGC2d LLC · Wilmington, DEBuilt 1997 · S/N 534N568GAGulfstream Aerospace Corp · Savannah, GABuilt 2019 · S/N 5608N568JLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5340N569DC56 Holdings LLC · Las Vegas, NVBuilt 2006 · S/N 9209N56BUBsi Holdings LLC · Portland, ORBuilt 2004 · S/N 5059N56CAusome Aviation LLC · Newark, DEBuilt 2012 · S/N 5396N575BGWmb Global 2018 LLC · Opa Locka, FLBuilt 2017 · S/N 9803N581DWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 5353N582DWeidner Property Management LLC · Kirkland, WABuilt 2012 · S/N 5397N585DSt Con Aviation LLC · Nashville, TNBuilt 2000 · S/N 597N585DWColleen Corp · New Castle, DEBuilt 2014 · S/N 5485N585JCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 618N586GDGulfstream Aerospace Corp · Savannah, GABuilt 2014 · S/N 5486N587GDGulfstream Aerospace Corp · Savannah, GABuilt 2015 · S/N 5520N5883Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 9118N588CV9354 Leasing LLC · West Palm Beach, FLBuilt 2009 · S/N 9354
Back to AD 2011-22-01