OpenAirDocs.org
AD 2002-23-13

Registered aircraft · 3,462

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-13')
    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-13')
  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.

N80243Deterding Aerial LLC · Pond Creek, OKBuilt 2020 · S/N 502B-3240N802AAMartinaire Aviation LLC · Addison, TXBuilt 2000 · S/N 208B0873N802BLLindeman Inc · Dhanis, TXBuilt 1994 · S/N 802A-0010N802BMEvergreen Flying Service Inc · Rayville, LABuilt 2005 · S/N 802A-0216N802BRAir Kraft Spraying Inc · Timber Lake, SDBuilt 2004 · S/N 802A-0171N802CWAurora Cooperative Elevator Company · Aurora, NEBuilt 2000 · S/N 802A-0103N802HAPontiac Flying LLC · Pontiac, ILBuilt 2005 · S/N 802A-0197N802HSSecurity Holdings LLC · Richmond, VABuilt 1995 · S/N 118N802LAAeronautical Technologies Inc · Clovis, NMBuilt 2001 · S/N 802A-0118N802MMAuburn Air Leasing LLC · Kalispell, MTBuilt 2002 · S/N 4697148N802QAWoodley Aerial Leasing LLC · Walnut, ILBuilt 2004 · S/N 802A-0194N802SGLocker Fred · Muleshoe, TXBuilt 2002 · S/N 802A-0135N802WPPorter Flying Service Inc · Chico, CABuilt 1998 · S/N 802A-0074N80341Pacific Valley Aviation Inc · Arbuckle, CABuilt 2024 · S/N 502B-3487N803JACaravan Flight Services LLC · Bayside, NYBuilt 1985 · S/N 20800016N803NCNorth Carolina Dept Of Agriculture And Consumer Se · Raleigh, NCBuilt 2023 · S/N 100-0322N804Abc Aviation LLC · Gonzales, LABuilt 1980 · S/N BB-724N804DGAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1999 · S/N 802A-0089N804FEFederal Express Corporation · Memphis, TNS/N 208B0039N804JHRocky Mountain Boat Co · Pueblo West, COBuilt 2001 · S/N 4697044N804THPa1 208b-0421 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0421N805DGWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0156N805DZSeattle Aircraft Rentals LLC · Bellevue, WABuilt 1990 · S/N 20800174N805ELKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2002 · S/N 208B0998N805KBDavid A Bush Inc · Hanford, CABuilt 2008 · S/N LJ-1924N805THAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0609N806JASomething Aviation LLC · Dekalb, ILBuilt 1985 · S/N 20800072N806JMFlorida Fish & Wildlife Conservation Commission · Lakeland, FLS/N BC-22N806KMMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1981 · S/N BB990N806LWSac Wild LLC · Loomis, CABuilt 1994 · S/N BB-1494N806WBCircle I Air LLC · Lubbock, TXBuilt 1982 · S/N BB-1047N807FERegistration Pending · Mountain View, CARegistration pendingBuilt 1987 · S/N 208B0041N807JAAv Serv LLC · Dover, DEBuilt 1985 · S/N 20800075N808MGMontague Aviation LLC · Inverness, MSBuilt 2012 · S/N 502B-2808N808PCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 77N808SWFmgi Inc · Woodstock, GABuilt 1978 · S/N LJ801N808TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIBuilt 1987 · S/N SH3718N8096UWhitty Aviation LLC · Rocklin, CABuilt 1993 · S/N LJ-1326N809SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 20800081N80LHLochsa Aviation LLC · Missoula, MTBuilt 1978 · S/N 801N80MALsc Construction Inc · Perris, CAS/N 31T7720043N80PMSouthbreeze Aviation LLC · Wellington, FLBuilt 1983 · S/N 425-0181N80RDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-21N80TMRad Holding I LLC · Olympia, WABuilt 2011 · S/N 259SRN80YDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-79N8104LTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N LJ-2004N8105VAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N LJ-2005N810VJVee Jay Equipment (De) LLC · Clarkston, MIBuilt 2005 · S/N 610N8116NStingray Aviation LLC · Visalia, CABuilt 1991 · S/N FL-58N811VMGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N 316
Back to AD 2002-23-13