OpenAirDocs.org
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.

N10330Buergel Sandra J · East Aurora, NYBuilt 1960 · S/N 72N10352Wichita Soaring Association Inc · Wichita, KSBuilt 1960 · S/N 81N10354Rebholz Mark A · Aguila, AZBuilt 1960 · S/N 82N10356Dobbins John R · Green Valley, AZS/N 195N10357Niagara Soaring Club · Williamsville, NYBuilt 1960 · S/N 85N10358Maglaughlin Ronald D · Udall, KSBuilt 1960 · S/N 84N10362Pursuit-Air-Crafters LLC · Crawford, COS/N 87N10366Szostak Edward M · San Diego, CABuilt 1960 · S/N 48N10367Neidert Melvin E · Ulysses, KSBuilt 1960 · S/N 88N10371Morgan Philip S · Dardanelle, ARBuilt 1960 · S/N 49N10372Registered aircraftBuilt 1960 · S/N 116N10374Wings Over Miami Museum Inc · Miami, FLBuilt 1961 · S/N 87N10378Lyon Richard K · Sun City, AZBuilt 1960 · S/N 69N10379Havener Michael D · Murrieta, CABuilt 1961 · S/N 113N10384Odonnell Daniel V · Dover, DEBuilt 1961 · S/N 100N10385Miller Bruce A · Plano, TXBuilt 1961 · S/N 119N10387Leary James · Ramona, CABuilt 1961 · S/N 123N10388Mohawk Soaring Club Inc · Hoosick Falls, NYBuilt 1960 · S/N 50N10389Kohler Richard L · Moriarty, NMBuilt 1961 · S/N 55N10392Canvasback Soaring · Port Murray, NJS/N 125N1102SBacon Robert J · Florence, MABuilt 1971 · S/N 502N1104SDocherty Dennis G · Boxborough, MABuilt 1971 · S/N 504N1105SRasmussen Steven T · Papillion, NEBuilt 1970 · S/N 500N1106SBrandywine Soaring Association · Hockessin, DEBuilt 1971 · S/N 501N1107SSugarbush Soaring Association Inc · Warren, VTBuilt 1971 · S/N 507N1108SSoaring Eagle Foundation · Peyton, COBuilt 1970 · S/N 478N1109SSeminole Soaring Club LLC · Clermont, FLBuilt 1970 · S/N 479N1113SMiller Blaine N · Brooks, GABuilt 1970 · S/N 480N1115SPost Mills Soaring Club · Norwich, VTS/N 505N1118SAero Club Albatross Inc · Blairstown, NJBuilt 1971 · S/N 508N111KLDraper William A Jr · Wichita, KSBuilt 1976 · S/N 458N1120SHoover Michael B · Ridgeland, WIBuilt 1971 · S/N 510N1126PGehrlein Jay L · Waterford, PAS/N 481N112CWilkinson Ephriam B · Eads, TNBuilt 1970 · S/N 482N1130SBockelman Michael · Lone Jack, MOS/N 61N1134SSky Sailing Inc · Warner Springs, CABuilt 1971 · S/N 514N1135SGluck Lewis · Wurtsboro, NYBuilt 1971 · S/N 515N1138SLoomiller Craig D · Disney, OKBuilt 1972 · S/N 518N1139SFault Line Flyers Inc · Leander, TXBuilt 1972 · S/N 519N113YZNevada Soaring Association Inc · Reno, NVBuilt 1973 · S/N 555N1141SRing Susan E · Hahira, GABuilt 1972 · S/N 521N1142SSchweizer Leslie E · Cayuta, NYBuilt 1972 · S/N 522N1143SNicholson Larry C · Calcutta, OHBuilt 1972 · S/N 523N1146SHonolulu Soaring Club Inc · Waialua, HIBuilt 1971 · S/N 76N1148SMullins Darrel L · Urbandale, IABuilt 1971 · S/N 58N1149SRasmussen Steven T · Papillion, NEBuilt 1972 · S/N 483N1155SBradburn David W · Capitan, NMS/N 484N1156SGreater Boston Soaring Club · Sterling, MABuilt 1971 · S/N 56N1160SSierra Soaring Club · Ridgecrest, CAS/N 60N1161SAntelope Valley Soaring Club Inc · Llano, CABuilt 1972 · S/N 239
Back to AD 87-17-01