OpenAirDocs.org
AD 2002-23-13

Registered aircraft · 3,461

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.

N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520N121LHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 425501049N121TDRegistration Pending · Montgomery, ALRegistration pendingBuilt 1979 · S/N 78-23138N1222BKelly Douglas E · Bethesda, MDBuilt 1980 · S/N 425-0060N1224WMaco Aviation Inc · Dayton, WABuilt 1998 · S/N 502A-0496N1229CKalinin Partners LLC · Juneau, AKBuilt 1996 · S/N 208B0589N1229ZKalinin Partners LLC · Juneau, AKBuilt 2002 · S/N 208B0943N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655N123FXFreefall Express · Gardiner, NYBuilt 1969 · S/N 200N123KQValiair Lc Trustee · Casper, WYBuilt 2009 · S/N 100-0013N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587N123TPatey Michael J · Spanish Fork, UTBuilt 2008 · S/N 00060024N1242YSkydive Baltimore LLC · Lincoln, DEBuilt 2002 · S/N 208B0939N124CTop Tier Truck And Trailer LLC · Amarillo, TXS/N EVO-029N124EBPremium Air LLC · Hibbing, MNBuilt 1995 · S/N FL-126N1256PPlanemasters Ltd · West Chicago, ILBuilt 1996 · S/N 208B0564N125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1982 · S/N LJ-1045N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422N125ZUsda Forest Service · Boise, IDBuilt 2017 · S/N 100-0226N1262TColdsteel Holdings LLC · Naples, FLBuilt 1987 · S/N 4250236N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250N126HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2014 · S/N 502B-2947N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595N126MMFreeman Holdings Of West Texas LLC · Medford, ORBuilt 2002 · S/N LJ-1669N126WAJpg & Aog LLC · Concord, NCBuilt 1984 · S/N LJ1093N1276YJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1113N1279DAircraft Partner Holdings Inc Trustee · BerlinBuilt 2007 · S/N LJ-1830N127ARAircraft Unlimited Inc · Pierre, SDBuilt 2004 · S/N 208B1055N127AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC76N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312N127MUSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N LJ-1102N127ZWAerolease LLC · Fargo, NDBuilt 1994 · S/N LJ1369N12813Razor Aviation Corp · Kalispell, MTBuilt 2000 · S/N 208B0808N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87N128STJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1133N128VTState Of Missouri · Jefferson City, MOBuilt 1992 · S/N BB-1442N128WWSpears Aerial Crop Care LLC · Mamou, LABuilt 2011 · S/N 502B-2793N1296YPa1 208b-1079 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1079N129EJShelbyville Auto Sales LLC · Shelbyville, TNBuilt 2001 · S/N 4697065N129EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-229N129JWAir Methods LLC · Greenwood Village, COBuilt 1996 · S/N 129N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129N129LCL R & F LLC · Dover, DEBuilt 1979 · S/N 31T7904042N129TNGuardian Flight LLC · Lewisville, TXBuilt 2005 · S/N LJ-1742N129TPHljh LLC · Corpus Christi, TXBuilt 2005 · S/N 629
Back to AD 2002-23-13