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.

N9187WAcadian Dusters LLC · Church Point, LABuilt 1993 · S/N 502-0220N9187ZEagle LLC · Sleepy Eye, MNBuilt 1993 · S/N 502-0223N918CACalifornia Highway Patrol · Sacramento, CABuilt 1978 · S/N BC-57N918DDDiamond D Aviation LLC · Sulphur, LABuilt 1999 · S/N BB-1677N918FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0018N918MTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1983 · S/N LA-211N9190VT&T Highcountry Flying Service LLC · Saint Anthony, IDFirst renewal noticeBuilt 1993 · S/N 402-0919N91918Thiel Air Care Inc · Chowchilla, CABuilt 1993 · S/N 502-0227N9192JAir Care Inc · Lamar, COS/N 502-0228N9193VMurtagh Flying Service Inc · Lexington, MSBuilt 1994 · S/N 502-0231N9194PLeading Edge Aero LLC · Southampton, NJBuilt 1993 · S/N 502-0233N91959Aslesen Leasin LLC · Halstad, MNBuilt 1994 · S/N 802A-0008N9195XRba LLC · Kimberly, IDBuilt 1993 · S/N 502-0235N9196CWoodley Aerial Leasing LLC · Walnut, ILBuilt 1994 · S/N 402A-0937N9196ZOscar Aviation LLC · Livonia, LAS/N 502B-0238N9197DT-C Aerial LLC · Littlefield, TXBuilt 1994 · S/N 502B-0240N919BGFreebird Aviation LLC · Monahans, TXBuilt 1984 · S/N EA-428N919GDAir Charter Inc DBA · Culebra, PRBuilt 1988 · S/N SH3740N919REIvy Brothers Aviation LLC · Kilgore, TXS/N BB824N91CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0054N91CTClemson University · Clemson, SCBuilt 1998 · S/N LJ-1521N91CVTwin P Aviation LLC · Fort Worth, TXBuilt 1991 · S/N 5600009N920FEFederal Express Corp · Memphis, TNS/N 208B0020N920TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N LJ-1300N921BSOld Dominion Aviation LLC · Statesville, NCBuilt 1993 · S/N FL-110N921FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0021N922JCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N LJ-1665N923FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0023N923JKMs Avation LLC · Waukesha, WIS/N FL-40N92409Piper Aircraft Inc · Vero Beach, FLBuilt 1990 · S/N 425501054N924ACDena'Ina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB483N925FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0025N925KHS660-131dc LLC · Keller, TXBuilt 2015 · S/N T660XP-131DCN925TKSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1992 · S/N 1021N926FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0026N926LADevil Dusters Inc · Artesia, NMBuilt 1993 · S/N 402-0911N927FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0027N927JTPikes Peak Flyers Llp · Colorado Springs, COBuilt 1991 · S/N LJ1263N928FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0028N928KAction Offshore LLC · Port Arthur, TXBuilt 1998 · S/N BB-1608N928KLKa-B200 LLC · San Angelo, TXBuilt 1994 · S/N BB-1482N928MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 1944 · S/N 32897N928PBMaranatha Leasing & Consulting Inc · Marco Island, FLBuilt 2005 · S/N 4697227N929BWSkyway K LLC · Middletown, DEBuilt 1998 · S/N BB-1630N929FDFaust Distributing Co Inc · Houston, TXBuilt 2000 · S/N LJ-1585N929FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0029N929KTRustair Inc · Anchorage, AKBuilt 1965 · S/N 461N929TGPa1 208b-0371 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0371N92CLAircraft Structures International Corp · Enid, OKBuilt 1989 · S/N 208B0185N92JJPa1 208b-1074 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1074
Back to AD 2014-17-08 R1