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.

N623LANeal Aircraft Inc · Slaton, TXBuilt 2000 · S/N 402A-1127N624ALUnderhill Holdings LLC · East Haven, CTBuilt 2006 · S/N 208B1183N626FCFlorida Department Of Agriculture And Consumer · Tallahassee, FLBuilt 1995 · S/N 35088N626LMOne Percent Aviation LLC · Lewes, DES/N 208B-0694N626NDay William B · Conroe, TXBuilt 1980 · S/N P-545N627EHHound Dog Enterprises LLC · Terre Haute, INBuilt 1991 · S/N T41-158N627EMMinton Air LLC · Alexandria, VABuilt 2025 · S/N 20800716N627LANew Frontier Aviation LLC · Fort Benton, MTBuilt 2005 · S/N 802A-0213N627PCAir First LLC · Kalispell, MTBuilt 1984 · S/N 425501010N628MCAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 516N629AAAllen Aviation Inc · Aynor, SCBuilt 2023 · S/N T660-182DCN629JPLj Leasing LLC · Cardington, OHBuilt 2002 · S/N 802A-0129N62HQGreen And White Air LLC · Kalamazoo, MIBuilt 1997 · S/N FL-156N62LTLima Tango LLC · Mariposa, CABuilt 2001 · S/N 4697027N62SALta Group Holdings LLC · Amarillo, TXBuilt 1997 · S/N LJ-1472N630LLCroom Aviation LLC · Port Saint Joe, FLBuilt 1994 · S/N T45-006DCN631BLBancfirst · Oklahoma City, OKBuilt 2005 · S/N 631N632DMAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 2009 · S/N 208B2132N634BTurbo Air Charter LLC · Boise, IDBuilt 1974 · S/N BC-19N63593Rbr Development LLC · West Plains, MOBuilt 1979 · S/N BB552N635BDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N BC-49N636BDavid Aviation Inc DBA · Brandon, MSBuilt 1978 · S/N BC-61N636KTRustair Inc · Anchorage, AKS/N 451N636QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2005 · S/N 636N636TAToth Financial Advisory Corp · Leesburg, VABuilt 2002 · S/N BB-1792N637LAMaxwell Flying Service Inc · Benoit, MSBuilt 2001 · S/N 502B-0637N637PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 627N637PHCapital Holdings 137 LLC · Tavernier, FLBuilt 2005 · S/N 637N63AWAmerican Ag Aviation Inc · Five Points, CABuilt 1998 · S/N 802A-0063N63TPHot Air LLC · Cambridge, MABuilt 1997 · S/N 128N63VAFairey Ltd · Grand Junction, COBuilt 1955 · S/N 850N640Teufel Holly Farms Inc · Portland, ORBuilt 1944 · S/N 1201N640MYManatee Jet Club LLC · Bradenton, FLBuilt 2005 · S/N 640N642Snow Goose Aviation LLC · Anchorage, AKBuilt 1968 · S/N 1204N642PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 642N644SDSierra Delta LLC · Lititz, PABuilt 2005 · S/N 644N645PCValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N 645N648DDDashdale Aviation LLC · Fort Dodge, IABuilt 1999 · S/N BB-1683N64FFSanford Health · Sioux Falls, SDBuilt 2000 · S/N FL-308N650DMMaroon Creek LLC · Aspen, COBuilt 1993 · S/N 85N651SDMontana Jj LLC · Big Sky, MTFirst renewal noticeBuilt 2020 · S/N 20800663N652JWWalters Aviation LLC · Hilliard, OHBuilt 2021 · S/N 4698188N653DPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N FA-193N654FMN654fm LLC · Kalispell, MTBuilt 1980 · S/N BB-654N655MWMarvin Lumber And Cedar Company · Warroad, MNBuilt 1999 · S/N UE-377N655SCStandridge Color Corp · Social Circle, GABuilt 1999 · S/N FL-239N658LAPontiac Flying LLC · Pontiac, ILBuilt 2003 · S/N 502B-0658N65MGRegistered aircraftN-number assigned (import), not yet registeredS/N LA-79N65MTM&M Transit LLC · Winter Park, FLS/N LA-38N65TADodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-538
Back to AD 2014-17-08 R1