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.

N786WWWestwind Aviation Inc · Phoenix, AZBuilt 2004 · S/N 208B1099N786ZAZulu Air LLC · Opa Locka, FLBuilt 1994 · S/N LJ1388N787FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0285N787TTMjw Aviation LLC · Beaumont, TXS/N LJ-787N788FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0286N788JMHarmon Foods Inc · Springfield, ILBuilt 2008 · S/N LJ-1868N78BABuckley Aviation LLC · Swainsboro, GABuilt 1998 · S/N LJ1529N78DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-78N78QRQrp Air LLC · Quincy, ILBuilt 2004 · S/N LJ-1699N78SAMartinaire Aviation LLC · Addison, TXBuilt 1995 · S/N 208B0467N78SVBba Aviation LLC · Raleigh, NCBuilt 1997 · S/N LJ-1504N790CPConocophillips Alaska Inc · Anchorage, AKBuilt 2018 · S/N 970N790FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0288N791DCExecutive Air Taxi Corporation · Bismarck, NDBuilt 1991 · S/N BB-1402N791EBSav Aviation LLC · Jacksonville, TXBuilt 1980 · S/N BB791N791SFFarrow Sammie N Jr · Cordele, GABuilt 1991 · S/N T34-162N792FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0290N793DCBillings Clinic · Billings, MTBuilt 1991 · S/N BB-1404N793MCThrush Aircraft LLC · Albany, GABuilt 2026 · S/N 510-162DCN793PPbmj LLC · Johnstown, PABuilt 2007 · S/N LJ-1836N794FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0292N794SDSd Aviation LLC · Syracuse, KSBuilt 2012 · S/N LJ-2046N795FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0293N795MKSouthern Palms Leasing LLC · Sarasota, FLBuilt 1985 · S/N 487N7979AGrowers LLC · Mohall, NDBuilt 2009 · S/N 502B-2664N7979BDasii LLC · Belview, MNBuilt 2011 · S/N 502B-2739N798FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0174N798JTSummit Skydive LLC · San Antonio, TXBuilt 2010 · S/N 171N798WCLonely Butte Management LLC · St George, UTBuilt 2005 · S/N 613N799ALDelt Holdings Orange LLC · Dubuque, IABuilt 1988 · S/N FA-157N799CZN799cz LLC · Milwaukee, WIBuilt 1969 · S/N U-68N799GKCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-799N79WDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-77N7CDGillis Stratton E · League City, TXBuilt 2019 · S/N 4698119N7LHSolesbee R Wendell · Yorba Linda, CABuilt 2012 · S/N EVO-015N7MCSt Tammany Parish Mosquito Abatement District · Slidell, LABuilt 1967 · S/N 40N7PPLj1919 Leasing LLC · Dos Palos, CABuilt 2008 · S/N LJ-1919N7SASla-Flyer LLC · Steamboat Springs, COBuilt 2005 · S/N 322N7TPDt Connect II LLC · New York, NYBuilt 1989 · S/N 760353N80Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-15N8002EParrish Aerial Services LLC · Wilmington, DEBuilt 2015 · S/N 502B-3043N8004Registration Pending · Kingsburg, CARegistration pendingBuilt 1983 · S/N H-4N80060Bank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 402B-1355N800BSM&F Western Products Inc · Sulphur Springs, TXBuilt 1998 · S/N BB-1620N800FRMatt Inc · Loveland, OHBuilt 2022 · S/N 4698225N800PGHelio Aircraft Inc · Fort Lauderdale, FLBuilt 1991 · S/N LJ-1286N801FLDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2000 · S/N 208B-0809N801GGLone Star Land & Cattle Co · Houston, TXBuilt 1993 · S/N FL-92N801JASpokane Turbine Skydiving LLC · Medical Lake, WABuilt 1985 · S/N 20800009N8021PArc-170 Aviation LLC · Santa Claus, INBuilt 1990 · S/N LJ-1269
Back to AD 2002-23-13