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.

N2202KDenkins Wayne L · Flushing, MIBuilt 1947 · S/N 4929N2204KBrem Ronald C · Bakersfield, CABuilt 1947 · S/N 4931N22051Fenger Paul L · Cottonwood, MNBuilt 1939 · S/N 877N22052Monaghan Richard C · Lenore, IDBuilt 1939 · S/N 878N2207KDyer Ben · Cincinnati, OHBuilt 1947 · S/N 4934N22087Webster David Ht · Columbia, TNBuilt 1939 · S/N 909N2208BSorenson Fred C · Las Vegas, NVBuilt 1949 · S/N 6635N2208KEldridge Andrea E · Donnelly, IDBuilt 1947 · S/N 4935N22091Shank Ronald D · Greensburg, KSBuilt 1939 · S/N 913N22098Forbis Greg S · Dewitt, MIBuilt 1939 · S/N 920N2210BWright Duane C · Sanford, FLBuilt 1949 · S/N 6637N2211KWittstock Duane C · Norwalk, IABuilt 1947 · S/N 4938N2212BAnderson Mark A · Bates City, MOS/N 6639N2212KBrown Kristen C · Independence, ORBuilt 1947 · S/N 4939N2213KJohnson Douglas L · Grass Valley, CAS/N 4940N2214BWilhite John R · Red Oak, TXBuilt 1949 · S/N 6641N2215KHubble Thomas A · Odessa, TXBuilt 1947 · S/N 4942N2216BGrass Brian S · Ocala, FLBuilt 1949 · S/N 6643N2219BPuls Kurt V · Valparaiso, INBuilt 1949 · S/N 6646N221BKThielen Andrew J · Atlantic, IABuilt 1947 · S/N 5288N2220BDavis David F · Oregon, ILBuilt 1949 · S/N 6647N2223KLopresti Stephen A · Marlborough, CTBuilt 1947 · S/N 4950N2225BGrove Robert L · Boerne, TXBuilt 1949 · S/N 6652N2225KJohnson Brian O · Alexandria, VABuilt 1947 · S/N 4952N2227KTraweek Brian C · Battle Mountain, NVBuilt 1947 · S/N 4954N2229BLaperle James · Greenville, CABuilt 1949 · S/N 6656N2229KProffett Paul G · Jupiter, FLBuilt 1947 · S/N 4956N2231KBishop Elijah Ar · Ukiah, CABuilt 1947 · S/N 4958N2233KHavens Jonathan D · Thornville, OHBuilt 1947 · S/N 4960N2234KMagnuson Lloyd W · Opelousas, LABuilt 1947 · S/N 4961N2235KVanderwal Calvin K · Burbank, SDBuilt 1947 · S/N 4962N2237BThoresen Brian D · Green Cove Springs, FLS/N 6664N2239KMagnuson Lloyd N · Opelousas, LABuilt 1947 · S/N 4966N2243BSlys Aircraft Service · Platte, SDBuilt 1950 · S/N 6670N2245BTardiff Richard A Trustee · Kealakekua, HIBuilt 1949 · S/N 6672N2246BBendelius Robert J · Accord, NYBuilt 1949 · S/N 6673N2251BWilliams Timoty L · Mckinney, TXBuilt 1949 · S/N 6678N2254KBlue Sky & Tailwheels LLC · Mary Esther, FLS/N 4981N2259KSilvaire Aviation LLC · Danville, INBuilt 1947 · S/N 4986N2260BFederal Aerial Applicators LLC · Wilmington, DEBuilt 1949 · S/N 6687N2261BObie Edgar L · Chinook, MTBuilt 1949 · S/N 6688N2262KWalker Kyle C · Juneau, AKBuilt 1947 · S/N 4989N2265KStephens Freddy P · Cairo, GAS/N 4992N2267KSmith Warren D · Oak Harbor, WAS/N 4994N2269KDelaney John T III · Bangor, PABuilt 1947 · S/N 4996N2271KWarner Isaac F · Three Rivers, CABuilt 1947 · S/N 4998N2281KWest Jack T · Lamar, COBuilt 1947 · S/N 5008N2282KGivens Benjamin T · Ruffin, SCBuilt 1947 · S/N 5009N2284KLind Ronald C · Rainier, WABuilt 1947 · S/N 5011N2290KHansen Christian F · Tucson, AZBuilt 1947 · S/N 5017
Back to AD 96-24-17 R1