OpenAirDocs.org
AD 75-08-17

Registered aircraft · 209

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:75-08-17')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-08-17')
  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.

N100ASKalitta Charters LLC · Ypsilanti, MIBuilt 1969 · S/N 274N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670N112PSFrontera Flight Holdings Inc · Dover, DEBuilt 1967 · S/N 47013N123RARoyal Air Freight Inc · Waterford, MIBuilt 1966 · S/N 30N127NKPerris Valley Airport Inc · Perris, CAS/N 47361N129TWLogistic Air Inc · Reno, NVBuilt 1976 · S/N 21141N140SCOrbital Sciences LLC · Mojave, CABuilt 1974 · S/N 193E1067N141WEOmega Air Inc · San Antonio, TXS/N 46661N148TWSierra American Corp · Wilmington, DEBuilt 1968 · S/N 148N155CAHeavylift Cargo Airlines Inc · Kingman, AZS/N 46073N158TWSierra American Corp · Wilmington, DEBuilt 1968 · S/N 158N164TSBank Of Utah Trustee · Salt Lake City, UTS/N 21119N165TSBank Of Utah Trustee · Salt Lake City, UTS/N 21523N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957N200CPSkyview LLC · Wilmington, DEBuilt 1972 · S/N 275N204TWSierra American Corp · Wilmington, DEBuilt 1969 · S/N 204N209CAAloft Aviation LLC · Hampton, GAS/N 71N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994N20FJDodson International Parts Inc · Rantoul, KSS/N 119N20WKRoyal Air Freight Inc · Waterford, MIBuilt 1974 · S/N 310N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213N221TWSierra American Corp · Wilmington, DEBuilt 1969 · S/N 221N227CKKalitta Charters LLC · Ypsilanti, MIBuilt 1970 · S/N 227N230TSDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N NA700N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956N23CJGrzechowiak Gary L · Denison, TXS/N 25152N24089Ploutz Lloyd · Modesto, CAS/N 20455N240CKKalitta Charters LLC · Ypsilanti, MIBuilt 1966 · S/N 24N244CKKalitta Air LLC · Ypsilanti, MIBuilt 1977 · S/N 369N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455N283SADodson International Parts Inc · Rantoul, KSS/N 83N287KBCsds Asset Management LLC · Marana, AZBuilt 1987 · S/N 49768N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467N291EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53039N292EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53208N293EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53209N294EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53210N295EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53211N296EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53212N297EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53213N303TWLogistic Air Inc · Reno, NVS/N 20116N31019Save A Connie Inc DBA · Kansas City, MOBuilt 1974 · S/N 193B-1066N326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIS/N 20917N353PAAersale Inc · Coral Gables, FLS/N 20622N370BCBcm Majestic Corp · Dallas, TXBuilt 1986 · S/N 23468N404DHDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 366
Back to AD 75-08-17