OpenAirDocs.org
AD 96-24-17 R1

Registered aircraft · 1,458

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:96-24-17-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:96-24-17-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.

N2086KBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 4813N2087BDavies Samuel R · Port Angeles, WABuilt 1948 · S/N 6514N2089BHales Janell W · Richland, WABuilt 1948 · S/N 6516N208DLRegistered aircraftBuilt 1947 · S/N 5478N2090KLang David W · Minot, NDS/N 4817N2095BCloudbase Assets Limited · Avon Lake, OHS/N 6522N2097BZubor Robert L Jr · Trevor, WIBuilt 1948 · S/N 6524N2101KGleitz Jay D · Longmont, COBuilt 1947 · S/N 4828N2105KKeller Joseph P Jr · Wakeman, OHBuilt 1947 · S/N 4832N2106BCaba Joseph · Covington, LAS/N 6533N2107BLanoue John Long Sr · Frost, TXBuilt 1948 · S/N 6534N2108BReitz Douglas A · Fresno, CABuilt 1948 · S/N 6535N2109BSchilling Aviation LLC · Britton, MIBuilt 1948 · S/N 6536N2117KTemptation Motors Ltd · Hayward, CABuilt 1947 · S/N 4844N2118BGahagan Stanley A · Jacksonville, TXBuilt 1949 · S/N 6545N211GMcneill Daniel A · Placerville, CABuilt 1949 · S/N 6684N2123BLovell Mark S · Templeton, CABuilt 1949 · S/N 6550N2124BKell Thomas G · Anchorage, AKS/N 6551N2126BSkychair LLC · Alexandria, VABuilt 1949 · S/N 6553N2128KPayne William C · Duluth, MNBuilt 1947 · S/N 4855N2129BValdez Marcos A · Fort Worth, TXS/N 6556N2132BRamin Jeanette J · Houston, TXBuilt 1949 · S/N 6559N2133KBradford William F · Independence, MOBuilt 1947 · S/N 4860N2136KCartwright Mark A · Manistique, MIBuilt 1947 · S/N 4863N2140BColvin Clu D DBA · Big Cabin, OKBuilt 1949 · S/N 6567N2140KWeatherbie Karen S · Centennial, COS/N 4867N2145BHorning Richard H · Galion, OHBuilt 1949 · S/N 6572N2145KNc2145k LLC · Fremont, OHS/N 4872N2149KVowell Greg · Coffeyville, KSBuilt 1947 · S/N 4876N2151KOyster Chris Randell · Bellville, OHBuilt 1947 · S/N 4878N2152BBolog Keith F · Kenosha, WIS/N 6579N2158KPachkofsky Donald S · Pleasant Hill, ORBuilt 1947 · S/N 4885N2159BRappa Giovanni · Hampton, VABuilt 1949 · S/N 6586N2163BMontgomery Douglas R · Fairbanks, AKBuilt 1949 · S/N 6590N2170KDykes William F · Laurel, MSBuilt 1947 · S/N 4897N2171KBeal Gary H · Hyde Park, VTBuilt 1947 · S/N 4898N2178BSouthern Utah University · Cedar City, UTBuilt 1949 · S/N 6605N2183BPhillips William L · Easthampton, MABuilt 1949 · S/N 6610N2188BCurtis Darrin M · Woodland, CABuilt 1949 · S/N 6615N2189BBolton Derwin B · Jacksonville, TXS/N 6616N2193Kreutzfeld Kenneth F · Marblehead, OHBuilt 1938 · S/N 810N2193BSmith David Seymour · Los Angeles, CABuilt 1949 · S/N 6620N2194BBarrett Larry E · Fenton, MIBuilt 1949 · S/N 6621N2197BRegistration Pending · Toledo, OHRegistration pendingS/N 6624N21996Sheets Mark W · Cedarburg, WIS/N 3423N22004Emory Robert N · Fort Mohave, AZBuilt 1938 · S/N 854N22013Baldwin Ranelle · San Luis Obispo, CABuilt 1938 · S/N 863N2201KKwasnik Joseph M · Brunswick, MEBuilt 1947 · S/N 4928N22020Wilder John G · Austin, TXBuilt 1938 · S/N 870N22023Beyer Jeffrey R · Slinger, WIBuilt 1939 · S/N 873
Back to AD 96-24-17 R1