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.

N700NAAtlanta Air Charter Inc · Kennesaw, GABuilt 1994 · S/N BB-1491N700PWBohica Consulting Services Inc · Boulder City, NVBuilt 2001 · S/N 211N700PXBjc Holdings Inc · Wheaton, ILBuilt 2002 · S/N 249N700RDPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1985 · S/N 31T5575001N700RESky Hawk LLC · Hamilton, MTBuilt 1994 · S/N 52N700RKBroodo Jack · Midland, MIBuilt 2002 · S/N 253N700SExciting Aviation LLC · Southport, CTBuilt 2001 · S/N 193N700TJHerrmann Holdings Inc · Cottonwood, CAS/N 27N700TLCosmos Holdings Group LLC · Newark, DEBuilt 2002 · S/N 227N700VBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 237N700VMEden Partners LLC · Edina, MNS/N 72N700WEJohnson Dean M · New Haven, CTBuilt 2001 · S/N 214N700WJFlorida State Guard · Tallahassee, FLBuilt 1981 · S/N 425-0036N700WWAces Full Inc · Deadwood, SDBuilt 1985 · S/N LJ-653N700YNPacific Wings Holdings LLC · Los Altos Hills, CABuilt 2002 · S/N 222N700ZZEastern Aviation Fuels Inc · New Bern, NCBuilt 1995 · S/N 116N7013FWimberly Lane W · Cochran, GABuilt 2012 · S/N T34-372N701AVTango Alpha Sierra LLC · Austin, TXBuilt 2000 · S/N 179N701CFLegacy Air 01 LLC · Grand Forks, NDBuilt 2005 · S/N 664N701CNScouts Rest Ranch LLC · Darby, MTBuilt 2003 · S/N 260N701DLPace J C III · Fort Worth, TXBuilt 2001 · S/N 20800344N701FCForum Communications Co · Fargo, NDBuilt 2000 · S/N FL-291N701FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0420N701GX9line LLC · Mountain Green, UTBuilt 2023 · S/N K047N701NTPioneer Agviation 2 LLC · Holdrege, NEBuilt 2012 · S/N 502B-2824N701SEFlorida Air Cargo Inc · Davie, FLBuilt 1998 · S/N 208B0701N701TVVaughns Flying Service Inc · Reese, MIBuilt 2011 · S/N T34-366DCN701WFSky King LLC · West Fargo, NDBuilt 1991 · S/N FL-47N701XPFlight Partners 2 LLC · Lincoln, NEBuilt 1979 · S/N LJ-826N702United States Dept Of The Interior · Boise, IDBuilt 2010 · S/N 100-0035N70224Agricair Leasing LLC · Bancroft, WIBuilt 2010 · S/N T34-341N7022FTommys Flying Service Inc · Sherrill, ARBuilt 2010 · S/N T34-334N7024JSchindler Flying Inc · Neligh, NEBuilt 2010 · S/N T34-336N702AALantech Leasing LLC · Louisville, KYBuilt 2001 · S/N 216N702AMHappy Boys LLC · Billings, MTBuilt 2021 · S/N 100-0300N702FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0422N702KAKenmore Air Harbor LLC · Kenmore, WABuilt 1954 · S/N 54N702LAJesse Shipman Farms LLC - Series A · Honey Grove, TXBuilt 2004 · S/N 502B-0702N702MCEveridge Aerial Farming Inc · Pinehurst, GABuilt 2023 · S/N 510-125N703CGMid Continent Aircraft Corp · Hayti, MOBuilt 2023 · S/N 510-515N704MDNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2004 · S/N 208B1076N705FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0425N705GGUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 48N706JRDodson International Parts Inc · Rantoul, KSS/N 42-5501050N706LBRf Logistics Inc · Santa Teresa, NMBuilt 1981 · S/N 4250033N706ZMarilyn Merlot LLC · Kalispell, MTBuilt 2000 · S/N 4636256N70715State Of Alaska · Anchorage, AKBuilt 1990 · S/N 20800182N707AVCarvair LLC · New York, NYBuilt 2001 · S/N 197N707FBBolea Air Inc · Morgan Hill, CAS/N 177N707FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0427
Back to AD 2002-23-13