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.

N84BDWhite Birch Transportation · Lee, NHBuilt 2002 · S/N 20800353N84EVNorth Coast Aeronautical Evo LLC · Cleveland, OHBuilt 2014 · S/N EVO-0062N84FCWilliams Fertilizer Services LLC · Oregon, MOBuilt 1994 · S/N 402-0946N84GDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-33N84HSGc N84hs LLC · Layton, UTS/N 50N84JLChieftain Equipment LLC · Longview, TXBuilt 1980 · S/N LA-18N84NEState Of Nebraska · Lincoln, NEBuilt 2014 · S/N LJ-2104N84TEDuncan Charles W III · Houston, TXBuilt 2020 · S/N 100-0284N85022Bergo LLC · Harrisburg, ARBuilt 2001 · S/N 402A-1140N8502ATumbleweed Leasing LLC · Tacoma, WABuilt 2002 · S/N 502-0647N8502HPope James D · Lewiston, IDS/N 802-0140N8504RRussell Armstrong And Danny Hawk DBA · Yuba City, CABuilt 2001 · S/N 802A-0123N8504TWakefield Aircraft LLC · Cooperstown, NDBuilt 2005 · S/N 802A-0218N8506VKubecka Daniel P · Edna, TXBuilt 2003 · S/N 502B-0650N8507KA & M Flying Service Inc · Carlise, ARBuilt 2001 · S/N 802A-0122N8507NTumbleweed Leasing LLC · Tacoma, WABuilt 2003 · S/N 802A-0158N8507SVan Namen Jonathan · Benoit, MSBuilt 2003 · S/N 502B-0664N8509SAir Tractor Inc · Olney, TXBuilt 2003 · S/N 802A-0164N8509TCrop Jet Aviation LLC · Gooding, IDS/N 802A-0152N850DTalfin Leasing LLC · Heflin, ALBuilt 1992 · S/N FL-70N850WRAg-Tech Aviation Inc · Leland, MSBuilt 2001 · S/N 502B-0643N8511QDaniels Aviation Inc · Inverness, MSS/N 602-0665N8516JG3 Flying LLC · Merigold, MSS/N 602-0671N8516KFlatland Aviation LLC · Indianola, MSBuilt 2003 · S/N 502B-0669N8519VAdams Aerial Solutions LLC · Decatur, ILBuilt 2004 · S/N 502B-0686N851EMLos Angeles Police Department · Los Angeles, CABuilt 1976 · S/N 73-22259N851FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0166N8521PThomas Air Service Inc · Hastings, NEBuilt 2004 · S/N 402B-1148N8521QCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2005 · S/N 502B-2572N8521VJones Flying Service · Biggs, CABuilt 2004 · S/N 602-0690N8521WA & M Flying Service Inc · Carlisle, ARBuilt 2004 · S/N 802A-0167N8521ZAir Care Leasing LLC · Lamar, COBuilt 2004 · S/N 502B-0693N8522SDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 802A-0161N8522YAero Applications Inc · Burley, IDBuilt 2004 · S/N 802A-0188N85239Shelton Agri Services Inc · Hereford, TXBuilt 2005 · S/N 602-1130N8523LTwin Cities Aviation Inc · Yuba City, CABuilt 2005 · S/N 802A-0203N8524FWallin Michael L · Walnut Ridge, ARBuilt 2005 · S/N 602-1132N8524HMitchell Andrew D Trustee · Winnie, TXS/N 802A-0163N8524LTri Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N 802A-0202N8524QMid-Cal Ag Aviation Inc · Kerman, CABuilt 2005 · S/N 502B-2580N8525FJlr Ag Aircraft LLC · Fowler, COBuilt 2005 · S/N 402B-1169N8525QMagnum Aviation LLC · Goff, KSBuilt 2005 · S/N 802A-0222N8525VKing Ag Leasing Inc · Sudan, TXS/N 502B-2568N8526HOld River Applicators LLC · Simmesport, LABuilt 2006 · S/N 502B-2595N8526LJack Olham Oil Inc · Dumas, TXBuilt 2005 · S/N 402B-1167N852DMHardscrabble Aviation LLC · Denver, COBuilt 2015 · S/N EVO-0059N853ALMetro Aviation Inc · Shreveport, LABuilt 1996 · S/N 168N853FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0170N854CMHeritage Aviation Management Ltd · Conroe, TXBuilt 2001 · S/N 208B0908N85516United States Department Of State · Melbourne, FLBuilt 1993 · S/N UE-61
Back to AD 2002-23-13