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.

N697JATactical Agriculture LLC · Upper Sandusky, OHBuilt 2010 · S/N 502B-2697N697PStaker & Parson Co · Ogden, UTBuilt 1985 · S/N BB1217N698DADirect Action Aviation LLC · Reno, NVBuilt 2011 · S/N 100-0052N698WWolstenholme Robert F · Redmond, ORFirst renewal noticeBuilt 2011 · S/N EVO-027N699BWBeech Transport LLC · Tarboro, NCBuilt 1999 · S/N BB-1658N699CCC & C Market Research Inc · Fort Smith, ARBuilt 1999 · S/N LJ-1553N699SAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1968 · S/N 669N699TPDoodle Aviation LLC · Burlington, NCBuilt 1985 · S/N FA-73N69ARRegistered aircraftBuilt 2024 · S/N 100-0333N69VGMontana First Coil LLC · Helena, MTBuilt 2013 · S/N LJ-2089N69XZJtac Systems LLC · Leonardtown, MDBuilt 1984 · S/N GM-96N6ATMayer Jon R · Reno, NVS/N 447N6FZZebra Air Adventures LLC · Atlanta, GABuilt 1999 · S/N 290N6RUSureal Vision Ltd · Waterford, NYBuilt 2011 · S/N EVO-008N6VAMidstates Aircraft Leasing LLC · Bern, KSBuilt 2022 · S/N 4698231N6VJN6vj LLC · Coleman, FLS/N LA88N6WLAurora Air LLC · Kalispell, MTBuilt 1975 · S/N 743N70009A-T Rental Properties LLC · Tivoli, TXBuilt 2011 · S/N T34-338N7001CThrush Aircraft LLC · Albany, GABuilt 2025 · S/N T660-190N7001NJefferson County Mosquito Control · Beaumont, TXBuilt 2025 · S/N 510-150DCN7003QLowry Flying Service Inc · Grinnell, IABuilt 2011 · S/N T34-343N7005BSky Force Travel LLC · Jamestown, NDBuilt 2011 · S/N T34-359N7005DThrush Aircraft LLC · Albany, GABuilt 2026 · S/N 510-161N7008MLongwood Flying Service Inc · Hollandale, MSBuilt 2011 · S/N T34-362N700ANAi Kinetics LLC · Los Altos, CABuilt 1998 · S/N 132N700APSutton Bay Leasing LLC · Excelsior, MNBuilt 2001 · S/N 190N700AYKellman Act Services Inc · Pacific Palisades, CABuilt 2001 · S/N 191N700BNBostic Capital Group LLC · Prestonsburg, KYBuilt 2001 · S/N 203N700BSPark Rapids Avionics Inc · Park Rapids, MNBuilt 1991 · S/N 11N700CFN7880l LLC · Port Charlotte, FLBuilt 1996 · S/N 123N700CSSocata 109 Inc Trustee · Wilmington, DEBuilt 1995 · S/N 109N700CTPatriot Contractors LLC · North Las Vegas, NVBuilt 2002 · S/N 236N700CVIlmo Adventures LLC · Kalispell, MTBuilt 2002 · S/N 221N700CZNexus Surgical Innovations Inc · Bozeman, MTBuilt 2004 · S/N 301N700DEPhoenix Trailers Aviation LLC · East Jordan, MIBuilt 2000 · S/N 184N700DTNorth Coast Ventures LLC · Wilmington, DEBuilt 1998 · S/N 134N700EBEcho Bravo LLC · Geneva, ILBuilt 2002 · S/N 215N700ELAir Twinlite Inc Trustee · Wilmington, DEBuilt 2002 · S/N 209N700ERBa Transportation Inc · Colonial Heights, VABuilt 2001 · S/N 198N700FWUnited States Dept Of The Interior · Boise, IDBuilt 2009 · S/N 100-0029N700FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0419N700GJRockland Key Aviation Inc · Wilmington, DEBuilt 2002 · S/N 241N700GNTinman LLC · Raleigh, NCBuilt 2002 · S/N 246N700HKDsl LLC · Las Vegas, NVS/N 60N700HNHartman Doyle · Aspen, COBuilt 2001 · S/N 204N700HYClear Blue Sky Aviation LLC · Hilton Head Island, SCBuilt 2004 · S/N 278N700JJIndependent Monitoring LLC · Los Altos, CABuilt 2002 · S/N 242N700LLGf Air LLC · Las Vegas, NVS/N 86N700LXLimpia Logistics LLC · Midland, TXBuilt 1999 · S/N BB-1657N700MYGpp Holdings LLC · Edmonds, WABuilt 1991 · S/N 31
Back to AD 2002-23-13