AD 74-18-13

Registered aircraft · 1,642

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:74-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
  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.

N33864Hirsch Bernard David · Carmel, INS/N 32-7500033N3386WTranswestern Air Service Inc · Golden, COBuilt 1965 · S/N 32-244N3388WTexas Wings LLC · San Antonio, TXBuilt 1965 · S/N 32-246N3389WUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1965 · S/N 32-247N3390WClear Blue Skies LLC · Saint Paul Park, MNBuilt 1965 · S/N 32-249N3391WNeckerauer John R · Acme, PABuilt 1965 · S/N 32-250N3392WMartinez Paul · Sonora, TXBuilt 1965 · S/N 32-251N3393DFiscus Ronald E III · Anchorage, AKS/N 32-40656N3395WGabrick Steven J · Hickory Valley, TNBuilt 1965 · S/N 32-255N3396WDaubert Donald W · Chandler, AZBuilt 1965 · S/N 32-256N3397WLarson Robb J · Danbury, WIBuilt 1965 · S/N 32-257N33JDRiggs Alan Vance · Artesia, NMBuilt 1979 · S/N 32-7940159N3400WTop Flight Aircraft Holdings LLC · Dover, DEBuilt 1966 · S/N 32-261N3402WCw Baker Investments LLC · Baton Rouge, LABuilt 1965 · S/N 32-262N3403WSchendel Daryl R · Barstow, CABuilt 1965 · S/N 32-264N3406WQwikflights LLC · Herriman, UTBuilt 1965 · S/N 32-267N3407WYounkin Anthony · Ruffs Dale, PABuilt 1966 · S/N 32-299N3410MArborio Peter J · Wethersfield, CTBuilt 1978 · S/N 32-7940001N3411WAmerican Airpower Museum · Farmingdale, NYBuilt 1965 · S/N 32-272N3412WN3412w LLC · Lithia, FLBuilt 1965 · S/N 32-274N3414WIrby Almous · Enterprise, ALBuilt 1965 · S/N 32-276N3415WSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 32-277N341SW13:4 Aviation LLC · Brookfield, WIBuilt 1969 · S/N 32-40592N3420WBuffington Brian C · Gillsville, GAS/N 32-280N3424WHobaugh Auto Parts Inc · Karns City, PABuilt 1965 · S/N 32-285N3427WHurricane Air LLC · Fremont, OHBuilt 1965 · S/N 32-313N3430WHerring Taylor R · Laredo, TXBuilt 1966 · S/N 32-291N3432WNunak Air Taxi LLC · Kenai, AKBuilt 1966 · S/N 32-329N3436WIsland Aviation Management LLC · Plainview, NYBuilt 1966 · S/N 32-297N3438WBlue Wanderers · Fort Wayne, INBuilt 1966 · S/N 32-302N3440WGood Earth Farms Inc · Hastings, NEBuilt 1965 · S/N 32-305N3441QBluegrass Skyriders LLC · Vine Grove, KYBuilt 1977 · S/N 32-7740063N3441WN3441w LLC · Shickley, NEBuilt 1965 · S/N 32-306N3442WRad Eye LLC · Wilmington, DEBuilt 1965 · S/N 32-307N3445WTrembly Alexander · Horner, WVBuilt 1965 · S/N 32-311N3447WStimart Rene D Trustee · Harshaw, WIBuilt 1965 · S/N 32-314N3450WRst Aviation LLC · Vero Beach, FLBuilt 1965 · S/N 32-317N3453WBrown Craig · Vernal, UTBuilt 1966 · S/N 32-321N3454WRoos Paul A · Lake City, FLBuilt 1966 · S/N 32-322N3455WClark James A · Walnut Creek, CABuilt 1966 · S/N 32-324N3457WBas Part Sales LLC · Greeley, COS/N 32-326N3458WBerquist Glenn A · Columbus, MSBuilt 1966 · S/N 32-327N3459WPannell Lucas J · Midland City, ALBuilt 1966 · S/N 32-330N3460WCarruth John T · Danvers, MNBuilt 1966 · S/N 32-331N3467WRobinhood Aero LLC · Southaven, MSS/N 32-340N3471WKoranda Amy B · Salem, SCBuilt 1966 · S/N 32-345N3476WFletcher Gayle J · Conroe, TXBuilt 1966 · S/N 32-352N3477WStevens Brad · Chandler, AZBuilt 1966 · S/N 32-353N3478WDouble D Air LLC · Killeen, TXS/N 32-354N3481WSandpiper Air LLC · Charles Town, WVBuilt 1966 · S/N 32-358
Back to AD 74-18-13