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.

N45461Shannon Agricultural Flying Inc · Clarksdale, MSBuilt 1990 · S/N 502-0124N45469Over & Under Flying Service Inc · Madison, INBuilt 1991 · S/N 402A-0797N45472Rtc Aviation LLC · Munday, TXBuilt 1991 · S/N 402A-0794N454CACul8tr LLC · Boynton Beach, FLBuilt 1982 · S/N 31T-8104053N454LFJamm Aviation Inc · Columbus, OHBuilt 1998 · S/N FL-209N454SFPa1 208b-0797 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B-0797N45506Mid Continent Aircraft Corp · Hayti, MOBuilt 1991 · S/N 502-0132N4550NNewberg Sky Spray LLC · Hector, MNBuilt 1991 · S/N 502-0131N4551MCady Leslie L · Rock Falls, ILBuilt 1991 · S/N 502-0133N45553Racer Aviation LLC · Moorestown, NJBuilt 1991 · S/N 402-0818N4555YDevil Dusters Inc · Artesia, NMBuilt 1991 · S/N 402-0812N4556UAir Care Leasing LLC · Lamar, COBuilt 1991 · S/N 402-0815N455MMMiklus Enterprises LLC · Middletown, DEBuilt 1980 · S/N 31T-8020087N455RSTfr Inc · Steamboat Springs, COBuilt 2005 · S/N 4697214N455SGDdog LLC · San Angelo, TXBuilt 2001 · S/N 4697096N456LAJaj Flying LLC · Sutton, NEBuilt 2005 · S/N 602-1131N457ATAeronautical Technologies Inc · Clovis, NMBuilt 2005 · S/N 802A-0201N45FLRegistered aircraftBuilt 1993 · S/N NC-45N461BBFlite Level Zero LLC · Stanfield, ORBuilt 2000 · S/N 4697016N461JADesign Builds LLC · West Point, VABuilt 2003 · S/N 4697168N461VFFlight International Corp Trustee · Flagstaff, AZS/N 46-8408049N463DBThunderhook Air Inc · Brentwood, TNBuilt 2009 · S/N 20800505N465MENorthlake Capital LLC · Ridgeland, MSBuilt 2005 · S/N 4697233N465SKAv8 LLC · Paso Robles, CABuilt 2000 · S/N 4697013N465TASouthwest Aviation Specialties LLC · Tulsa, OKS/N LJ630N465TPMountain Holding Inc · Cody, WYBuilt 2005 · S/N 4697204N468SPPacific Mission Aviation · Hagatna, GUBuilt 1998 · S/N BB1639N468ZBBrown Helicopter Inc · Pensacola, FLBuilt 1988 · S/N 760345N469BUnited States Construction Corporation · Pompano Beach, FLBuilt 1978 · S/N LJ-803N469SBK-Town Aviation LLC · Louisville, TNBuilt 2003 · S/N 4697162N46AEBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N LJ-1582N46CECentury Equipment Company Inc · Salt Lake City, UTBuilt 1994 · S/N BB1492N46MEFishlover'S Management LLC · Chandler, AZBuilt 2005 · S/N 4697207N46PLAvcorp Leasing Inc Trustee · Wilmington, DEBuilt 2001 · S/N 4697054N470MMSfc Global Supply Chain Inc · Marshall, MNBuilt 2000 · S/N UE-394N473QHBrown Helicopter Inc · Pensacola, FLBuilt 1986 · S/N 760331N4757SBombay Glass Corp · Depoe Bay, ORS/N 4697006N476XPMatonti James Robert · BanglamungRegistration ineffective or invalidBuilt 1968 · S/N 2040N477HCParish Air Inc · San Diego, CABuilt 2003 · S/N 4697171N477JMBehrens Aircraft Leasing LLC · Waukesha, WIBuilt 1979 · S/N BB-538N477XPParaclete Aviation LLC · Raeford, NCBuilt 2000 · S/N 208B0833N478CRAlg Aircraft LLC · Delano, CABuilt 1997 · S/N LJ-1474N479BCm Aviation LLC · Corsicana, TXBuilt 2002 · S/N FL-338N479SAEarthcom Inc · Williamston, MIBuilt 1967 · S/N LJ215N479VATactical Aviation Inc · Wilmington, DEBuilt 1998 · S/N BB1601N47CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0033N481ZGalazy Lift II LLC · New York, NYBuilt 1973 · S/N LW-52N485JRGuardian Flight LLC · Lewisville, TXBuilt 1997 · S/N 20800264N485YUGen Board Of Global Ministries Of The United Metho · Atlanta, GAS/N 208B0970N488XJPartnership Management Inc · Midland, TXBuilt 1998 · S/N LJ-1527
Back to AD 2014-17-08 R1