AD 2001-22-10

Registered aircraft · 474

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

N529SGM G S Aviation Inc · Miami, FLBuilt 2011 · S/N 259N539CAResmed Inc · San Diego, CABuilt 2007 · S/N 181N53FJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 53N544CMFalcon Fawzi III LLC · Fort Lauderdale, FLBuilt 1995 · S/N 152N54HGFifth Avenue Aviation LLC · Naples, FLBuilt 2004 · S/N 140N54YPPhifer Inc · Tuscaloosa, ALBuilt 2003 · S/N 333N550SHFalcon 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 10N555CKCarroll Aviation LLC · Wilmington, DEBuilt 2003 · S/N 125N556HDN50hd LLC · Salt Lake City, UTBuilt 2002 · S/N 321N55HSRapid Leasing Inc · Cedar Rapids, IABuilt 1998 · S/N 276N571CBKba Bridges & Shields LLC · East Point, GABuilt 1984 · S/N 001N575JJTm Aircraft Leasing LLC · Wilmington, DEBuilt 2006 · S/N 163N577QTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 262N57KTKlein Tools Inc · Lincolnshire, ILBuilt 2002 · S/N 110N581STOakwood Books Inc · Charlottesville, VABuilt 2016 · S/N 300N588HPRbg Operations II LLC · Wilmington, DEBuilt 2015 · S/N 288N58CGCorning Inc · Corning, NYBuilt 2015 · S/N 289N58HLGreen Button Holdings LLC · Overland Park, KSBuilt 1999 · S/N 279N590CLInternational Aviation LLC · Wheeling, ILBuilt 2003 · S/N 132N598WCWaste Connections US Inc · Houston, TXBuilt 2016 · S/N 305N59YPNextgen Flying LLC · The Villages, FLBuilt 1998 · S/N 275N5VJFalconagain Inc · New York, NYBuilt 2001 · S/N 099N600JBOgden Aviation LLC · Hinsdale, ILBuilt 1998 · S/N 272N600JMEast Lake Jet Aviation LLC · Montauk, NYS/N 05N600LYMajjec Jhett LLC · Springfield, MABuilt 2004 · S/N 337N601GS1 Trophy Husband LLC · Omaha, NEBuilt 2007 · S/N 184N609CQFalki LLC · Winter Springs, FLBuilt 2012 · S/N 265N610RLFalconrl LLC · Missoula, MTBuilt 1988 · S/N 68N611TXMegaequipment LLC · Wilmington, NCBuilt 2005 · S/N 143N613BHBoz Holdings LLC · St Thomas, VIBuilt 2005 · S/N 159N615FJMegatel Group Services LLC · Dallas, TXS/N 102N615MSMss Falcon 900 LLC · Denver, COBuilt 2006 · S/N 160N617DVCae III Ltd · Wilmington, DEBuilt 1997 · S/N 20N620DXAdams Aviation Services Inc Trustee · Wilmington, DES/N 620N622WMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 147N626AWHfl Aviation LLC · Dallas, TXBuilt 2006 · S/N 168N627CRArrowhead Aviation Inc · Batesville, ARBuilt 1999 · S/N 048N62NWE7 Alpha LLC · Austin, TXBuilt 2009 · S/N 233N636SJHrm Aviation LLC · Chesterfield, MOS/N 104N63JPZap Magic LLC · New Castle, DEBuilt 2010 · S/N 249N649TTTownes Aircraft Sales LLC · Paris, TXBuilt 2005 · S/N 342N655TCTlc Aircraft Leasing LLC · Vero Beach, FLBuilt 2002 · S/N 195N661MSLone Star Avalanche LLC · Marble Falls, TXBuilt 1987 · S/N 011N667HFBd Plane Inc · Chicago, ILBuilt 1987 · S/N 25N66FJAlpha Mike Aviation LLC · Murfreesboro, TNBuilt 2000 · S/N 66N670JDAmber Services Inc · Chicago, ILBuilt 1988 · S/N 45N672WVWrbc Transportation Inc · Greenwich, CTBuilt 2014 · S/N 280
Back to AD 2001-22-10