AD 2002-23-20

Registered aircraft · 384

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

N5190Bsc Horizon LLC · Saint Louis, MOBuilt 2003 · S/N 122N521CLWerner Enterprises Inc · Omaha, NEBuilt 2009 · S/N 213N522TLDodson International Parts Inc · Rantoul, KSS/N 98N527PJas Air LLC · New Windsor, NYBuilt 2013 · S/N 275N527SRedleaf Management Company LLC · Miami, FLS/N 8N529SGM 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 140N550SHFalcon 55 LLC · West Bradenton, FLBuilt 2010 · S/N 230N550THAmc 50 LLC · Wilmington, DEBuilt 2001 · S/N 100N551ADAci Partners LLC · Ewing Township, NJBuilt 1997 · S/N 10N555CKCarroll Aviation LLC · Wilmington, DEBuilt 2003 · S/N 125N571CBKba 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 289N590CLInternational Aviation LLC · Wheeling, ILBuilt 2003 · S/N 132N598WCWaste Connections US Inc · Houston, TXBuilt 2016 · S/N 305N5VJFalconagain Inc · New York, NYBuilt 2001 · S/N 099N600JMEast Lake Jet Aviation LLC · Montauk, NYS/N 05N601GS1 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 249N655TCTlc 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 280N673HBSigma Equity LLC · San Francisco, CABuilt 2005 · S/N 153N675AZJetco LLC · Kalamazoo, MIBuilt 2012 · S/N 268N67ELWard Ohara Companies LLC · Kansas City, MOBuilt 1995 · S/N 153N687HA687 Holdings LLC · Newark, DEBuilt 2010 · S/N 232
Back to AD 2002-23-20