AD 87-17-01

Registered aircraft · 905

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

N1164SConnecticut Soaring Association Inc · New London, CTBuilt 1972 · S/N 64N1166SBlanton Robert D · Wichita, KSBuilt 1972 · S/N 66N1167SKite Adam H · Ogden, UTBuilt 1972 · S/N 67N1169SCypress Soaring Inc · Hemet, CABuilt 1972 · S/N 69N1170SRefugio Soaring Circle Inc · Refugio, TXBuilt 1972 · S/N 70N1172SValley Soaring Club Inc · Middletown, NYBuilt 1972 · S/N 72N1173SFlint River Soaring LLC · Bainbridge, GABuilt 1972 · S/N 233N1176SSky Sailing Inc · Warner Springs, CABuilt 1971 · S/N 226N1179SSchwam Julie R · Hayden, IDS/N 229N1182SDouglas Paul W · Brooklyn, WIBuilt 1972 · S/N 232N1184SBates Marcus L · Leander, TXS/N 234N1185SFault Line Flyers · Leander, TXBuilt 1972 · S/N 235N1186SMohawk Soaring Club · Hoosick Falls, NYBuilt 1972 · S/N 236N1187SAir Biscuit LLC · Williamson, GABuilt 1972 · S/N 237N1188SFault Line Flyers · Leander, TXBuilt 1972 · S/N 238N1189SSkysurfing Hawaii LLC · Waialua, HIBuilt 1972 · S/N 62N1190SSky Sailing Inc · Warner Springs, CABuilt 1971 · S/N 227N1191SCivil Air Patrol · Maxwell Afb, ALBuilt 1967 · S/N 5N1196SBlack Industries LLC · Helena, MTBuilt 1970 · S/N 196N1200SRetroair Restoration LLC · Big Lake, AKBuilt 1970 · S/N 200N1226GWest Michigan Aviation Academy · Grand Rapids, MIS/N 397N1227SKutztown Aviation Service Inc · Germansville, PABuilt 1971 · S/N 212N1228SConnecticut Soaring Association Inc · New London, CTBuilt 1971 · S/N 213N1229SBurbank Franklin R · Ocala, FLBuilt 1971 · S/N 214N1232SN292 Ac Flyers LLC · Brandon, MSBuilt 1971 · S/N 216N1233SIroquois Soaring Association · Rome, NYBuilt 1971 · S/N 217N1239SSky Sailing Inc · Warner Springs, CABuilt 1971 · S/N 221N1242SNew England Soaring Association · North Springfield, VTBuilt 1971 · S/N 224N126AOliver John F Trustee · Chula Vista, CAS/N 38N126BWilkinson Ephriam B · Eads, TNBuilt 1964 · S/N 275N126BAAnderson Austin R · Capitan, NMS/N 284N126BVCollins Dennis L · Richland, WABuilt 1968 · S/N 422N126CPHamilton Soaring Club Inc · Hamilton, TXBuilt 1974 · S/N 612N126CRMhr Leasing LLC · Hickory Corners, MIS/N 649N126DDungan Gregory David · Boca Raton, FLBuilt 1964 · S/N 81N126DBBlack-Nixon C Dianne · Wayne, NJBuilt 1971 · S/N 516N126EWilkinson Ephriam B · Eads, TNBuilt 1974 · S/N 608N126ERHobbs Martin Lowell · Old Fort, NCBuilt 1955 · S/N 4N126HDMahony Thomas Charles · Mcmurray, PABuilt 1974 · S/N 597N126HWCooper Remel R Jr Trustee · Green Cove Springs, FLBuilt 1967 · S/N 372N126JLErnst Daniel D · Poquoson, VAS/N 316N126MDGrand Lake Air Ventures LLC · Celina, OHBuilt 1974 · S/N 599N126MHSky Sailing Inc · Warner Springs, CABuilt 1973 · S/N 576N126MNStanton Sport Aviation · Stanton, MNBuilt 1965 · S/N 319N126NKRegistered aircraftS/N 675N126RMSteinmetz Peter N Trustee · Tempe, AZS/N 585N126SFGrace Lance C · Alamogordo, NMBuilt 1974 · S/N 610N126SGLowry Wilson R · Leonardtown, MDBuilt 1963 · S/N 102N126TDOliver Thomas M · Littlefield, AZBuilt 1974 · S/N 596N126TULeroy Philippe G · Willcox, AZS/N 409
Back to AD 87-17-01