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.

N1003KScott Michelle · Vallejo, CABuilt 1946 · S/N 3730N1005KKing Richard J II · Rose Creek, MNBuilt 1946 · S/N 3732N100CRFreudenberg Joseph B · Almira, WABuilt 1947 · S/N 5050N1013KBall Jeffrey A · Harrison, ARBuilt 1946 · S/N 3740N1015KMichaud Paul · Forest Lake, MNBuilt 1946 · S/N 3742N1029KCrabbe Michael B · Galloway, OHBuilt 1946 · S/N 3756N1034KSpivey Harold E · Thomaston, GABuilt 1946 · S/N 3761N1035KDrake Thomas E · Phoenix, AZBuilt 1946 · S/N 3762N1040KKoons Brian D · Canton, OHBuilt 1946 · S/N 3767N1042KCorporate Aircraft Leasing Co · Newton Falls, OHS/N 3769N1045KWilder Kirk E · Boonville, CABuilt 1946 · S/N 3772N1046KCuny John B · Carlsborg, WABuilt 1946 · S/N 3773N1050KLynden Aeronautical Services LLC · Lynden, WABuilt 1946 · S/N 3777N1057KLips Paul A · Waxahachie, TXBuilt 1946 · S/N 3784N1064KStein Andrew · Modesto, CABuilt 1946 · S/N 3791N1072KAlley Shane C · Jackson, MOS/N 3799N1078KClairday Preston H · Melbourne, ARS/N 3805N1080KLindsey Harold D · Wichita Falls, TXBuilt 1946 · S/N 3807N1082KBoese Erich DBA · Oakdale, CABuilt 1946 · S/N 3809N1087KMiller Robert L III DBA · Kittrell, NCBuilt 1946 · S/N 3814N1088KTaylor Spencer H · Lake City, FLBuilt 1946 · S/N 3815N1091KThompson Isaac R · Stoutsville, OHBuilt 1946 · S/N 3818N1097KWerner Glenn M · Hartwell, GABuilt 1946 · S/N 3824N1100KWilkie David J · Nashua, NHBuilt 1946 · S/N 3827N1101BMchugh Ronna R · Salem, ORBuilt 1947 · S/N 5728N1104BTimmons Colton R · Yuma, AZBuilt 1947 · S/N 5731N1104KJohnson Christopher · Danville, INBuilt 1946 · S/N 3831N1107BBacon Joseph M · Fenton, MIBuilt 1947 · S/N 5734N1107KButtonwillow Land & Cattle Co · Buttonwillow, CABuilt 1946 · S/N 3834N1109BWeymouth James H · Jackson, MIBuilt 1947 · S/N 5736N1109KCard William N III · Schwenksville, PABuilt 1946 · S/N 3836N110QSilvaire Air LLC · Gun Barrel City, TXBuilt 1948 · S/N 5983N110SLaysoncraft LLC · Clarkston, MIBuilt 1960 · S/N S-79N1113BSky Monkey Tailwheels LLC · Richardson, TXBuilt 1947 · S/N 5740N1114BGiddens Ronald E · Boynton Beach, FLS/N 5741N1115BBradley Lawrence A · Lafayette, CAS/N 5742N1116BRogers Douglas M · Milwaukee, WIBuilt 1947 · S/N 5743N1116KSexton Robert D · Sugar Grove, VAS/N 3843N1117BAnderson Marlin R · Malta, ILBuilt 1947 · S/N 5744N1118BFraser Christopher D · Gig Harbor, WABuilt 1947 · S/N 5745N1125BHansen Michael L · Williamson, GABuilt 1947 · S/N 5752N1126KBrushwitz Ronald C Jr · Salem, ILBuilt 1946 · S/N 3853N1128KMitchell Peter J · Concord, CABuilt 1946 · S/N 3855N1131BBurnett Ronald L · Dardenne Prairie, MOBuilt 1947 · S/N 5758N1136BLambasio Francis T · Canton, ILBuilt 1947 · S/N 5763N1137BReed Jimmy A · Big Cabin, OKBuilt 1947 · S/N 5764N1139BJohnston Lance M · Bellingham, WABuilt 1947 · S/N 5766N1139KClairday Joey · Melbourne, ARBuilt 1946 · S/N 3866N1142BWood Ross H · Stuttgart, ARBuilt 1947 · S/N 5769N1143BBaker Joseph P · Matthews, NCBuilt 1947 · S/N 5770
Back to AD 96-24-17 R1