OpenAirDocs.org
AD 98-17-01 R1

Registered aircraft · 1,201

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:98-17-01-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:98-17-01-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.

N652CCSu-N16 LLC · Oak Creek, WIBuilt 1999 · S/N 650-7107N653CCRegistered aircraftBuilt 2000 · S/N 650-7116N653FJDwts LLC · Powder Springs, GAS/N 110N654CPN654cj LLC · Williamsburg, VAS/N 113N655MDMargarita Flights LLC · Longwood, FLBuilt 2004 · S/N 258655N655PEDunbar Aviation LLC · West Kingston, RIBuilt 1982 · S/N 199N655TCTlc Aircraft Leasing LLC · Vero Beach, FLBuilt 2002 · S/N 195N657DJCastiron 5 LLC · Wilmington, DEBuilt 1983 · S/N 094N65MLBae Systems Technology Solutions & Services Inc · Mojave, CABuilt 1981 · S/N 465-69N660PAFriendly Aviation LLC · Dallas, TXBuilt 1993 · S/N 650-0230N663TWButler National Inc · New Century, KSBuilt 1990 · S/N 35A-662N664MMAquarius Aircraft Leasing LLC · Nashville, TNBuilt 1984 · S/N 650-0037N666KLWj Of Delaware Inc · Fort Lauderdale, FLS/N 040N667HFBd Plane Inc · Chicago, ILBuilt 1987 · S/N 25N667WJConnell Blue LLC · Berkeley Heights, NJBuilt 2004 · S/N 258667N669MDDmc Aviation LLC · Scottsdale, AZBuilt 1992 · S/N 068N669RARoyal Air Freight Inc · Waterford, MIS/N 669N66GESunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-28N66VAFranco Plastering Inc · Naples, FLBuilt 1983 · S/N 375N66ZBCharter Equipment Leasing LLC · Bellevue, WABuilt 2004 · S/N 258675N670JDAmber Services Inc · Chicago, ILBuilt 1988 · S/N 45N671MMKmwflight LLC · Wilmington, DEBuilt 1984 · S/N 258014N671RRAircraft Fidelity Corp Trustee · Dover, DEBuilt 1993 · S/N 258244N673HBSigma Equity LLC · San Francisco, CABuilt 2005 · S/N 153N676GHNoll Air LLC · Orlando, FLBuilt 2004 · S/N 258676N67ELWard Ohara Companies LLC · Kansas City, MOBuilt 1995 · S/N 153N67FSBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 650-0029N67PWNunya LLC · Irvine, CABuilt 1994 · S/N 248N680JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 349N680KTSay Tony S · Oklahoma City, OKBuilt 1981 · S/N 77N682DN682d LLC · Wilmington, DES/N NA0431N686BCDodson International Parts Inc · Rantoul, KSS/N 039N689WTotal Prf LLC · Lewes, DEBuilt 1984 · S/N 650-0045N68CBCracker Barrel Old Country Store Inc · Lebanon, TNBuilt 1999 · S/N 258453N68LMAmerica Aviation LLC · Yuma, AZBuilt 1982 · S/N 100N696JMFalcon Aviation Services LLC · Dallas, TXBuilt 1987 · S/N 28N696RGPecos Bend Royalties Lllp · Midland, TXBuilt 1997 · S/N 265N699BGWord Of Life Christian Center Inc · Darrow, LABuilt 1990 · S/N 082N699GGMcair1 LLC · Duck, NCBuilt 1999 · S/N 182N699MWYahweh Property LLC · Houston, TXBuilt 1999 · S/N 049N69BSDspa LLC · Baton Rouge, LABuilt 2001 · S/N 138N69VHKolob Canyons Air Services Inc · Wilmington, DEBuilt 1982 · S/N 062N6FJFlying Farmer LLC · Wilmington, DEBuilt 1977 · S/N 97N6NRSdi Aviation LLC · Rhinelander, WIBuilt 2004 · S/N 258701N700LWAircraft Resource Center Inc · Lakeville, MNBuilt 1986 · S/N 650-0125N700MHMotor City Aeronautics LLC · Okemos, MIBuilt 1986 · S/N 650-0127N700PGAviation Xx LLC · Wilmington, DEBuilt 2004 · S/N 137N700RRDaxen Logistic LLC · Chino, CABuilt 1978 · S/N NA-0217N700SRMd Jet Aviation Services Inc · Wilmington, DEBuilt 1983 · S/N 079N702SMTeam Aero LLC · Olathe, KSS/N 650-0135
Back to AD 98-17-01 R1