OpenAirDocs.org
AD 94-18-04 R1

Registered aircraft · 1,310

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:94-18-04-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:94-18-04-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.

N6504QKnutson Wayne R · Thompson, NDBuilt 1966 · S/N A-104N6505QRegistered aircraftBuilt 1966 · S/N A-105N6506QHogan Earle S Jr · Kenbridge, VABuilt 1966 · S/N A-106N6508QShipley Ronald L · Lemon Grove, CABuilt 1966 · S/N A-108N6511QBryant David A · Rosamond, CABuilt 1966 · S/N A-111N6512QSmith Jess T · Willows, CABuilt 1966 · S/N A-112N6513QFrank George W Jr · Evansville, INS/N A-113N6515QHoward Roland L · Forsyth, MTBuilt 1966 · S/N A-115N6516QHolt Dennis J · Leetonia, OHBuilt 1966 · S/N A-116N6518QMaurer Sara A · Anchorage, AKBuilt 1966 · S/N A-118N6522QPrice Richard H · Corryton, TNS/N A-122N6525QMoore Robert Wayne · Brenham, TXBuilt 1966 · S/N A-125N6526QRevette Richard L · Littleton, COBuilt 1966 · S/N A-126N6527QSlifkin Lester H · Arcadia, CABuilt 1966 · S/N A-127N6529QWill Peter J · Westminster, COBuilt 1966 · S/N A-129N6532QValley River Leasing Inc · Murphy, NCBuilt 1966 · S/N A-132N6534QGregory Vernon L · Swansea, SCBuilt 1966 · S/N A-134N6537QGoodwin Greg J · Cleveland, TXBuilt 1966 · S/N A-137N6538QShaw Monte L · Hillsboro, OHS/N A-138N6539QMcginnis Louis F · Raton, NMBuilt 1966 · S/N A-139N6543QAnderson Kenneth J · Norman, OKBuilt 1966 · S/N A-143N6544QRush Paul E · Highland, KSBuilt 1966 · S/N A-144N6545QRegistered aircraftBuilt 1966 · S/N A-145N6547QOwen Mark L · Clyde, TXBuilt 1966 · S/N A-147N6548QBuenger Sam · Seabrook, TXBuilt 1966 · S/N A-148N6549QRoman Luis M · Miami, FLBuilt 1966 · S/N A-149N6550QMarden Michele · Erwinna, PABuilt 1966 · S/N A-150N6551QFitzhenry Thomas M · Richfield, MNBuilt 1966 · S/N A-151N6555QGabbert Douglas S · Palm Coast, FLBuilt 1965 · S/N A-55N6556QGabrail Peter S · Greer, SCBuilt 1965 · S/N A-56N6557QLee Jan · Sandpoint, IDBuilt 1965 · S/N A-57N6558QDelgado Joaquin C Jr · Kingwood, TXBuilt 1965 · S/N A-58N6559QWest Alert Security Services Inc · Clearlake Park, CABuilt 1965 · S/N A-59N6564QGrimes James Rex · Carlton, GABuilt 1965 · S/N A-64N6565QBeicker Dennie L · Hernando, MSBuilt 1965 · S/N A-65N6566QGregoire Norris Scott · Walla Walla, WABuilt 1965 · S/N A-66N6567QPhillips Raymond B · Inver Grove, MNS/N A-67N6568QLaliberte George A Trustee · Topeka, KSBuilt 1965 · S/N A-68N6569QWiddows Michael J · Thousand Oaks, CABuilt 1965 · S/N A-69N6570QAviation Training Inc · Cameron Park, CAS/N A-70N6571QKarpov Andre W · Newark, DES/N A71N6572QCarlton Davis E · Grove, OKS/N A-72N6573QHolcomb Gene · Memphis, TNS/N A-73N6576QGeisen Timothy L · San Pedro, CABuilt 1965 · S/N A-76N6579QMonske Nicholas J · Austin, TXBuilt 1965 · S/N A-79N6580QThomas Dale A · Gooding, IDBuilt 1965 · S/N A-80N6581QBachman Ernest J · New Brighton, PABuilt 1965 · S/N A-81N6583QBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N A-83N6585QJones Steve · Torrance, CABuilt 1965 · S/N A-85N6594QFantasy Fighters Inc · Santa Fe, NMBuilt 1966 · S/N A-94
Back to AD 94-18-04 R1