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.

N45425O Brien A Scott · Santa Rosa Valley, CABuilt 1945 · S/N 1952N45426Registered aircraftBuilt 1956 · S/N 1953N45432Hansen Joseph L · Alden, IABuilt 1945 · S/N 1959N45435Scholz Mark W · Atchison, KSBuilt 1945 · S/N 1962N45463Burns Jeffery T · Independence, ORBuilt 1945 · S/N 1990N45468Cornett John R Jr · Lexington, KYBuilt 1946 · S/N 1995N45475Andraka Andrew M · Newport News, VABuilt 1946 · S/N 2002N45481Turiak Ryan J · Lugoff, SCFirst renewal noticeS/N 2008N45484Varvayanis Mark · Dryden, NYBuilt 1946 · S/N 2011N45488Heitkotter Shari · Ridgecrest, CABuilt 1946 · S/N 2015N45489Mumford Kenneth E · Kailua, HIS/N 2016N45493Garringer David A · Colville, WABuilt 1946 · S/N 2020N45494Bolton Derwin B · Jacksonville, TXBuilt 1946 · S/N 2021N45499Almeida Gilbert M · Hilmar, CABuilt 1946 · S/N 2026N454LELinden Thomas D · Mcfarland, WIBuilt 1949 · S/N 6599N45504Zazas James B · Carthage, NCBuilt 1946 · S/N 2031N45514Mick Edward H · Glassboro, NJBuilt 1946 · S/N 2041N45518Michael Jeffrey R · Port Orange, FLBuilt 1946 · S/N 2045N45519Day Wayne E · Des Moines, IABuilt 1946 · S/N 2046N45527Reed Gretchen M · Madison, OHBuilt 1946 · S/N 2054N45532Wall Craig M · San Antonio, TXBuilt 1946 · S/N 2059N45534Jorgensen Ronald C · Askov, MNBuilt 1946 · S/N 2061N45538Fiorello Stephen J · North Bellmore, NYBuilt 1946 · S/N 2065N45544Ganther Kenneth R Jr · Olathe, KSBuilt 1946 · S/N 2071N45549Beail Herschel D · Quincy, CAS/N 2076N45555Phillips Robert L · Wilkesboro, NCS/N 2082N45561Stevens Linda J · Caldwell, IDBuilt 1946 · S/N 2088N45564Young Robert G · Naugatuck, CTBuilt 1946 · S/N 2091N45565Puzio Joseph E · Butler, TNS/N 2092N45567Passburg James O · Montpelier, VTBuilt 1946 · S/N 2094N45569Go Leasing Co · Phillipsburg, KSBuilt 1946 · S/N 2096N45577Glassburn Hugh S · Ephrata, WAS/N 2104N45583Whitehead Keith A · Port Saint Joe, FLBuilt 1946 · S/N 2110N45594Morris Aaron J · Newman Lake, WAS/N 2121N45595Gillman Ryan J · Hamburg, NYBuilt 1946 · S/N 2122N45598Makepeace Mike C · El Dorado, ARBuilt 1946 · S/N 2125N45604Gavlak Edward C · Cincinnati, OHBuilt 1946 · S/N 2131N45610Johnson Leslie R · Saint Paul, MNBuilt 1946 · S/N 2137N45619Swager Garren J · Rancho Cucamonga, CABuilt 1946 · S/N 2146N45628Erl Don L · Medford, WIS/N 2155N45631Poluton Doug · Castro Valley, CAS/N 2158N45634Sittig Robin A · Sioux Falls, SDBuilt 1946 · S/N 2161N45635Whitmore Alex · Terlingua, TXBuilt 1946 · S/N 2162N45641Miller Erik J · Gilbert, AZBuilt 1946 · S/N 2168N45642Clough Douglas P · Graham, WABuilt 1946 · S/N 2169N45647Beatty Rose E · Hollister, CABuilt 1946 · S/N 2174N45651Atkinson Karl A · Athol, IDBuilt 1946 · S/N 2178N45653Lewis Bruce E · Oxford, MEBuilt 1946 · S/N 2180N45658Scheevel Thomas E · Preston, MNFirst renewal noticeBuilt 1946 · S/N 2185N45661Andrasik William J · Sagamore Hills, OHBuilt 1946 · S/N 2188
Back to AD 96-24-17 R1