OpenAirDocs.org
AD 2014-17-08 R1

Registered aircraft · 2,525

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.

N119RFRandigo LLC · Wilmington, DEBuilt 2002 · S/N 208B0929N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502N11DGAir Grace LLC · Blanco, TXBuilt 2024 · S/N K060N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9N120WWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 4697047N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243N12155Martinaire Aviation LLC · Addison, TXBuilt 1996 · S/N 208B0562N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336N121HARedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0069N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520N121TDRegistration Pending · Montgomery, ALRegistration pendingBuilt 1979 · S/N 78-23138N1222BKelly Douglas E · Bethesda, MDBuilt 1980 · S/N 425-0060N1224WMaco Aviation Inc · Dayton, WABuilt 1998 · S/N 502A-0496N1229CKalinin Partners LLC · Juneau, AKBuilt 1996 · S/N 208B0589N1229XTalkeetna Aero Services Inc · Anchorage, AKBuilt 1992 · S/N 20800212N1229ZKalinin Partners LLC · Juneau, AKBuilt 2002 · S/N 208B0943N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122N1232YPa1 208b-0566 LLC · Fort Lauderdale, FLBuilt 1996 · S/N 208B0566N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655N123FXFreefall Express · Gardiner, NYBuilt 1969 · S/N 200N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587N1242YSkydive Baltimore LLC · Lincoln, DEBuilt 2002 · S/N 208B0939N124EBPremium Air LLC · Hibbing, MNBuilt 1995 · S/N FL-126N124RFRandigo LLC · Wilmington, DEBuilt 1988 · S/N 20800018N1258BSouthern Airways Pacific LLC · Addison, TXBuilt 2007 · S/N 208B1258N125RFRandigo LLC · Wilmington, DEBuilt 2012 · S/N 208B2330N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595N126RFRandigo LLC · Wilmington, DEBuilt 2005 · S/N 208B1156N1276YJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1113N127ARAircraft Unlimited Inc · Pierre, SDBuilt 2004 · S/N 208B1055N127AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC76N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312N127RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0350N12813Razor Aviation Corp · Kalispell, MTBuilt 2000 · S/N 208B0808N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87N128STJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1133N1296STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 208B1296N1296YPa1 208b-1079 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1079N129CGSchuman Carriage Co Ltd · Honolulu, HIBuilt 2007 · S/N 208B1290N129EJShelbyville Auto Sales LLC · Shelbyville, TNBuilt 2001 · S/N 4697065N129JWAir Methods LLC · Greenwood Village, COBuilt 1996 · S/N 129N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129N129LCL R & F LLC · Dover, DEBuilt 1979 · S/N 31T7904042N129TPHljh LLC · Corpus Christi, TXBuilt 2005 · S/N 629
Back to AD 2014-17-08 R1