AD 2010-26-05 R1

Registered aircraft · 1,068

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

N515MFAh Jag LLC · Atlanta, GABuilt 2008 · S/N 191N515PVPilot Travel Centers LLC · Knoxville, TNBuilt 2012 · S/N 702N516CJTotal Aviation Corp · Garden City, NYBuilt 1980 · S/N 016N516DGFalcon Air LLC · Los Angeles, CAFirst renewal noticeBuilt 2000 · S/N 116N516JAKings Aviation Corp · Garden City, NYBuilt 1991 · S/N 089N518SSFalconsn100 LLC · Roslyn, NYBuilt 1999 · S/N 100N5190Bsc Horizon LLC · Saint Louis, MOBuilt 2003 · S/N 122N519JDDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 198N520AWGg Flight LLC · Findlay, OHBuilt 1981 · S/N 453N520SCStryker Corp · Portage, MIBuilt 2017 · S/N 338N520TCDodson International Parts Inc · Rantoul, KSS/N 319N521CLWerner Enterprises Inc · Omaha, NEBuilt 2009 · S/N 213N521FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 68N522EECenergistic LLC · Dallas, TXBuilt 1999 · S/N 282N522TLDodson International Parts Inc · Rantoul, KSS/N 98N526DJMs Falcon LLC · East Spring Valley, NYBuilt 2003 · S/N 211N527DAJory Aviation LLC · Edina, MNBuilt 2023 · S/N 406N527PJas Air LLC · New Windsor, NYBuilt 2013 · S/N 275N527SRedleaf Management Company LLC · Miami, FLS/N 8N529KGCapstone Management LLC · Manchester, NHBuilt 2014 · S/N 292N529SGM G S Aviation Inc · Miami, FLBuilt 2011 · S/N 259N531FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 113N531JDRonin Tori Leasing LLC · Bloomfield Hills, MIBuilt 2007 · S/N 135N5379FN5379f LLC · Canton, OHBuilt 2002 · S/N 203N539CAResmed Inc · San Diego, CABuilt 2007 · S/N 181N53FJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 53N53LTVpc Aviation LLC · Valencia, CABuilt 2007 · S/N 108N53NJLear 100kz LLC · Burnet, TXBuilt 2002 · S/N 174N541FBank Of Utah Trustee · Salt Lake City, UTS/N 435N541ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 312N542TPLakeridge Holdings LLC · Portland, ORBuilt 2006 · S/N 089N544CMFalcon Fawzi III LLC · Fort Lauderdale, FLBuilt 1995 · S/N 152N54DRGarcia David D · Midlothian, TXS/N 94N54HGFifth Avenue Aviation LLC · Naples, FLBuilt 2004 · S/N 140N54MHTvpx Msn 390 Business Trust · North Salt Lake, UTBuilt 2022 · S/N 390N54YPPhifer Inc · Tuscaloosa, ALBuilt 2003 · S/N 333N54YRPhifer Inc · Tuscaloosa, ALBuilt 2015 · S/N 300N550SHFalcon 55 LLC · West Bradenton, FLBuilt 2010 · S/N 230N550THAmc 50 LLC · Wilmington, DEBuilt 2001 · S/N 100N550WMWno Trust Services LLC Trustee · Wilmington, DEBuilt 1992 · S/N 229N551ADAci Partners LLC · Ewing Township, NJBuilt 1997 · S/N 10N552GRGrp Aviation LLC · Van Nuys, CABuilt 2009 · S/N 160N553GRRivers Edge Equipment Leasing LLC · Springfield, ILBuilt 1998 · S/N 64N555CKCarroll Aviation LLC · Wilmington, DEBuilt 2003 · S/N 125N555GSInvestjet LLC · Miami, FLBuilt 2001 · S/N 149N555HGShort Hills Aviators LLC · Morristown, NJBuilt 2007 · S/N 102N555MKNgl Aviation Tul LLC · Tulsa, OKBuilt 2005 · S/N 59N5567AAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 98N556HDN50hd LLC · Salt Lake City, UTBuilt 2002 · S/N 321N556KMFifty-One Air LLC · Lampasas, TXBuilt 2007 · S/N 121
Back to AD 2010-26-05 R1