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.

N832PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9837N835HCHood Capital LLC · Hattiesburg, MSBuilt 2017 · S/N 6292N837ZPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5393N838KEDtc LLC · Newburgh, NYBuilt 2012 · S/N 5398N838SWAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1999 · S/N 9035N83ML3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2014 · S/N 5470N83VPRegistered aircraftBuilt 2000 · S/N 614N83WGCooper Burger LLC · Coral Gables, FLBuilt 1999 · S/N 9030N843FFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9574N843GXAlesant Air LLC · Miami, FLBuilt 1999 · S/N 9026N846CBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6269N848JAD S Advisors Inc · Oak Park, ILBuilt 2004 · S/N 5047N84YUTxpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 9300N851WUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5342N857GAPpg Industries Inc · West Mifflin, PABuilt 2019 · S/N 5596N858KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5438N85DRegistered aircraftBuilt 2001 · S/N 9078N85JMCook Canyon (Gp) LLC · Dallas, TXBuilt 2012 · S/N 5369N85NVKhosla Ventures LLC · San Jose, CABuilt 1997 · S/N 513N85VTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 595N863CMWeh 601 LLC · Wilmington, DEBuilt 2021 · S/N 9488N864JGBowtie Aircraft Xrs LLC · Aventura, FLBuilt 2019 · S/N 9864N865RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5211N866BBHff Xpressed LLC · Naples, FLBuilt 2014 · S/N 5466N868KETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6272N869DLN869dl LLC · Kansas City, MOBuilt 2006 · S/N 5136N86ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5270N86DQQdn Aviation LLC · New Canaan, CTBuilt 2014 · S/N 5489N870CMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5076N871FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 6304N875TMTai Leasing Inc · Mckinney, TXBuilt 2015 · S/N 5526N877SBSb Companies LLC · San Antonio, TXBuilt 2017 · S/N 5555N878DBThorondor LLC · Palo Alto, CAFirst renewal noticeBuilt 2007 · S/N 5167N878GCGraton Economic Development Authority · Rohnert Park, CABuilt 2003 · S/N 5025N878SCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9614N87WDWeeks-Davies Aviation Inc · West Palm Beach, FLBuilt 2001 · S/N 649N880SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5426N880XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9806N882PXNewage Aviation I LLC · Arcadia, CABuilt 2004 · S/N 5015N882WRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5576N883AFunair Corp · Aventura, FLBuilt 2007 · S/N 5175N883SJBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 5279N884SGRegistered aircraftBuilt 2011 · S/N 5319N885AREssseaeff Aviation LLC · Jericho, NYBuilt 2008 · S/N 5224N885KTJustifly LLC · Dallas, TXBuilt 2018 · S/N 6323N886BPSun Air Three LLC · Scottsdale, AZBuilt 2011 · S/N 9453N887MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5321N887TMTai Leasing Inc · Mckinney, TXBuilt 2010 · S/N 5294N888HEGolden Sky Inc · Camden, DEBuilt 2001 · S/N 638N888JELeone Management Inc · Camden, DEBuilt 2005 · S/N 5070
Back to AD 2011-22-01