OpenAirDocs.org
AD 2014-17-08 R1

Registered aircraft · 2,524

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:2014-17-08-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-17-08-R1')
  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.

N699BWBeech Transport LLC · Tarboro, NCBuilt 1999 · S/N BB-1658N699SAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1968 · S/N 669N69XZJtac Systems LLC · Leonardtown, MDBuilt 1984 · S/N GM-96N6CBPk Aviation LLC · Melbourne, FLBuilt 2024 · S/N 20800704N6VAMidstates Aircraft Leasing LLC · Bern, KSBuilt 2022 · S/N 4698231N6VJN6vj LLC · Coleman, FLS/N LA88N7001CThrush Aircraft LLC · Albany, GABuilt 2025 · S/N T660-190N700ANAi 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 301N700DTNorth Coast Ventures LLC · Wilmington, DEBuilt 1998 · S/N 134N700ELAir Twinlite Inc Trustee · Wilmington, DEBuilt 2002 · S/N 209N700ERBa Transportation Inc · Colonial Heights, VABuilt 2001 · S/N 198N700FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0419N700GNTinman LLC · Raleigh, NCBuilt 2002 · S/N 246N700HYClear 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 31N700NAAtlanta Air Charter Inc · Kennesaw, GABuilt 1994 · S/N BB-1491N700PWBohica Consulting Services Inc · Boulder City, NVBuilt 2001 · S/N 211N700RDPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1985 · S/N 31T5575001N700RESky Hawk LLC · Hamilton, MTBuilt 1994 · S/N 52N700SExciting Aviation LLC · Southport, CTBuilt 2001 · S/N 193N700TJHerrmann Holdings Inc · Cottonwood, CAS/N 27N700VBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 237N700WJFlorida State Guard · Tallahassee, FLBuilt 1981 · S/N 425-0036N700YNPacific Wings Holdings LLC · Los Altos Hills, CABuilt 2002 · S/N 222N700ZZEastern Aviation Fuels Inc · New Bern, NCBuilt 1995 · S/N 116N701AVTango Alpha Sierra LLC · Austin, TXBuilt 2000 · S/N 179N701CNScouts Rest Ranch LLC · Darby, MTBuilt 2003 · S/N 260N701FCForum Communications Co · Fargo, NDBuilt 2000 · S/N FL-291N701FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0420N701GX9line LLC · Mountain Green, UTBuilt 2023 · S/N K047N701SEFlorida Air Cargo Inc · Davie, FLBuilt 1998 · S/N 208B0701N701WFSky King LLC · West Fargo, NDBuilt 1991 · S/N FL-47N702AALantech Leasing LLC · Louisville, KYBuilt 2001 · S/N 216N702FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 208B0422N702LAJesse Shipman Farms LLC - Series A · Honey Grove, TXBuilt 2004 · S/N 502B-0702N702SEFlorida Air Cargo Inc · Davie, FLBuilt 1993 · S/N 208B0374N703CGMid Continent Aircraft Corp · Hayti, MOBuilt 2023 · S/N 510-515N703DCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20800366
Back to AD 2014-17-08 R1