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.

N890FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0219N891AAAugusta Aviation Inc · Augusta, GAFirst renewal noticeBuilt 1989 · S/N LJ-1221N891FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0221N891JCAllen Chorman & Son Inc · Milton, DEBuilt 1999 · S/N T34-269N891LMn Aircraft LLC · Carolina, PRBuilt 2002 · S/N 208B0938N891WTBoettcher Aerial Co · Beloit, KSBuilt 2013 · S/N 502B-2906N892FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0222N893APAcadian Aircraft Leasing LLC · Rangeley, MEBuilt 2018 · S/N 100-0249N894FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0224N895FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0015N895SFNorth East Ventures C LLC · Danielson, CTBuilt 1988 · S/N 208B0095N896CMXrp Investments LLC · Clyde, MIBuilt 1980 · S/N BB-668N897FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0227N898ABBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 502B-3078N898AJNext Gen Air LLC · Colorado Springs, COBuilt 2005 · S/N 662N898BRElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1986 · S/N BB-1255N899BAReliance Air LLC · Conway, ARBuilt 1993 · S/N LJ-1344N899FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0235N89FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1969 · S/N LM-124N89JLDag Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N LA19N89KQBell Financial Services Ltd · Broken Arrow, OKBuilt 2013 · S/N 100-0089N8FHIron Sky Capital LLC · Lubbock, TXBuilt 1997 · S/N LJ-1477N8GFVivace International Corp · San Antonio, TXBuilt 1991 · S/N 1011N8KULange Jonathan E · Seattle, WABuilt 2004 · S/N 304N8UMSkytravel Inc · Houston, TXBuilt 2001 · S/N 4697067N8YWAv Serv LLC · Dover, DEBuilt 1996 · S/N 113N9002KAerial Timber Applicators Inc · Cooperstown, NDBuilt 1999 · S/N 802-0078N9006QCrider Flying Service · Swifton, ARBuilt 1992 · S/N 502A-0190N900CTRoughneck Supply LLC · Muskogee, OKBuilt 1995 · S/N LJ-1398N900HSBizair LLC · Wilmington, DEBuilt 1996 · S/N 136N900LAFlying G Aviation Inc · Drayton, NDBuilt 2014 · S/N 502B-2957N900MTLincoln Ventures LLC · North Highlands, CABuilt 1983 · S/N LJ1048N900SSUpland Aviation LLC · Medford, ORBuilt 2020 · S/N 100-0283N900WAWright Air Service Inc · Fairbanks, AKBuilt 1998 · S/N 208B0659N900ZZ110me Inc · Lake Providence, LABuilt 1983 · S/N EA-398N901AKA C Sunni LLC · Santa Monica, CABuilt 2000 · S/N 616N901BSParaclete Aviation LLC · Raeford, NCBuilt 1968 · S/N 160N901DMCordonnier Andrew · San Diego, CABuilt 2001 · S/N 4697051N901STSky Team Aviation Inc · Wilmington, DEBuilt 1999 · S/N 208B0752N90210Robertson Crop Dusting Service Inc · South Haven, MIBuilt 1992 · S/N 402-0889N902AKDillon Aero Inc · Phoenix, AZBuilt 1988 · S/N 560N902DBBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N LJ1202N902FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0002N902KAValiair Lc Trustee · Casper, WYBuilt 2014 · S/N LJ-2100N902MAMaxwell Ag Aviation LLC · Sterling, KSBuilt 2005 · S/N 502B-2592N902STTrue North Aviation LLC · Mulino, ORFirst renewal noticeBuilt 2009 · S/N 153N90319Stevenson Flying Service Ll · Selden, KSBuilt 1999 · S/N 502B-0578N9032TBarts Flying Service Inc · Storm Lake, IABuilt 2000 · S/N 402A-1130N9033NJohn Georg Aerial LLC · La Crosse, KSBuilt 1999 · S/N 402A-1097N9037NOutwest Aviation LLC · Hamilton, MTBuilt 1999 · S/N 802A-0083
Back to AD 2002-23-13