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.

N311MXInternational Air Services Inc Trustee · Carson City, NVBuilt 2022 · S/N 4698213N312BCWorldwide Option LLC · Lewes, DEBuilt 1994 · S/N 101N312JVSpitfire Ventures LLC · San Antonio, TXBuilt 1995 · S/N 480N312LARoth Aerial Spraying LLC · Milford, NEBuilt 2015 · S/N 502B-3022N312RLNyati Worldwide LLC · Sinton, TXBuilt 1997 · S/N FL-164N312SBSwitchback Aviation LLC · Roscoe, MTBuilt 2022 · S/N 100-0309N3133LBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N LJ-1873N313DWDurair Inc · Key West, FLBuilt 1996 · S/N LJ-1434N313HAValiair Lc Trustee · Casper, WYBuilt 1993 · S/N FL-96N313TWWiebe Aerial Applications LLC · Whitewater, KSBuilt 2013 · S/N 502B-2890N314AWUS Government · Washington, DCBuilt 2004 · S/N FL-387N315AWUS Government · Washington, DCBuilt 1992 · S/N FL-91N315WSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501015N3160XWoodley Aerial Leasing LLC · Walnut, ILBuilt 1983 · S/N 301-0479N316LVBayne Air LLC · Whitefish, MTBuilt 2025 · S/N K097N316PDLonghorn Air LLC · Wilmington, DEBuilt 2003 · S/N 14038N316PMAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 241N316PWAl Force 1 LLC · North Salt Lake, UTBuilt 1991 · S/N FM2N316WRHoxie Sprayers Inc · Hoxie, KSBuilt 1995 · S/N 502A-0316N317XTN317xt LLC · Henderson, NVBuilt 2022 · S/N 100-0317N318LGLow Go Flyers Inc · Jonesville, LABuilt 2014 · S/N T34-421DCN31941Gasper Air Spray Inc · Crookston, MNBuilt 1995 · S/N T45-008N319EEReveille Aviation LLC · Kurten, TXBuilt 2004 · S/N FL-401N319LACrop Air LLC · Eaton, COBuilt 2015 · S/N 502B-3019N319PDAerotrust Services Corp Trustee · Wilmington, DEBuilt 2004 · S/N 14040N319TBShuck Holdings LLC · Anderson, SCBuilt 2005 · S/N 319N319WWWin Win Aviation Inc · Wake Forest, NCBuilt 1992 · S/N SH3209N31JA100-042 LLC · Menlo Park, CABuilt 2010 · S/N 100-0042N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49N31WDWestern Dakota Holding Co · Timber Lake, SDBuilt 1980 · S/N 425-0012N31XXTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1990 · S/N FL-31N320N320 LLC · North Las Vegas, NVBuilt 2023 · S/N 100-0328N320KAKismet Aviation LLC · Oldenburg, INBuilt 2010 · S/N LJ-1985N320KTRustair Inc · Anchorage, AKBuilt 1956 · S/N 73N321N321 LLC · North Las Vegas, NVBuilt 2021 · S/N 100-0299N3211RJohnson Airspray Inc · Argyle, MNBuilt 1978 · S/N 5100RN3216KSouth River Services LLC · Myrtle Beach, SCS/N LJ-1392N321ATBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 502B-2746N321CWBatte Bennie S · Forest, MSBuilt 1999 · S/N 155N321CYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1968 · S/N 211N321DASherer Robert O · Deadwood, SDBuilt 1991 · S/N 402A-0814N321FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1979 · S/N BC-70N321HXGggg LLC · Hilton Head Island, SCBuilt 1981 · S/N 425-0104N321PDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1980 · S/N GR-10N322N322 LLC · North Las Vegas, NVBuilt 2019 · S/N 100-0273N3220LPee Dee Aviation LLC · Florence, SCBuilt 1995 · S/N LJ-1420N3221MGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1621N322HGH & O Aviation LLC · Oxford, MSBuilt 1993 · S/N FL-93N322MRPf Aircraft LLC · Graham, TXBuilt 2000 · S/N LJ-1611N322MTSkyak LLC · Chanhassen, MNBuilt 2022 · S/N 4698237
Back to AD 2002-23-13