OpenAirDocs.org
AD 94-05-05 R1

Registered aircraft · 26,231

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-05-05-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-05-05-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.

N4284CHarbin Dennis M · Louisa, VABuilt 1966 · S/N 64-11N4284FNolen Collin · Newman Lake, WABuilt 1958 · S/N 46184N4284UBaker Ranches Inc · Baker, NVBuilt 1963 · S/N 15060284N42853Aero Applications Inc · Burley, IDS/N 15173N4285NSchrag Jeremy M · Garden Plain, KSBuilt 1947 · S/N 13756N4286NSteffen Jeffrey W · Crofton, NEBuilt 1947 · S/N 13757N4286VArquer Nicholas R · Rancho Cucamonga, CABuilt 1948 · S/N 18700N42881Edwards Christopher V · Seattle, WAS/N 15212N4288EKelley Gavin E · Heath, TXBuilt 1947 · S/N 11CC-158N4288UPiper Kenneth R · Orwell, VTBuilt 1964 · S/N 15060288N4288VPeck Kenneth L · Smithville, TXBuilt 1948 · S/N 18646N42895Terhune Robert W Jr · Augusta, KSBuilt 1945 · S/N 15230N42896Vaughn Michael R · Saint Augustine, FLBuilt 1945 · S/N 15231N4289NKingsley Clint · Cerritos, CABuilt 1947 · S/N 13760N4289VRosborough Todd · Medford, ORBuilt 1948 · S/N 18647N428CAJones Steven L · Winnebago, MNS/N 428N4290FRussi Kent S · Caldwell, IDBuilt 1958 · S/N 46190N4290NAlbion Aerial Sprayers Inc · Sargent, NEBuilt 1947 · S/N 13761N4291ENodorft Aviation LLC · Orlando, FLBuilt 1947 · S/N 11CC-163N4291LRappa Giovanni · Hampton, VABuilt 1966 · S/N 17254360N4291PVanderploeg Connie · Edmond, OKS/N 0432N4291UTheis Industrial Leasing Inc · Spivey, KSBuilt 1963 · S/N 15060291N4291WN4291w LLC · Orlando, FLBuilt 1969 · S/N 15071397N42926Smith Roger D · Fayetteville, NCBuilt 1945 · S/N 15277N4292NRegistered aircraftBuilt 1947 · S/N 13763N4292UHayes John Lue · Shady Cove, ORFirst renewal noticeBuilt 1963 · S/N 15060292N4292VPowers James E · Elk, WABuilt 1948 · S/N 18650N4293LO'Hop Robert D · Jones, OKBuilt 1966 · S/N 17254362N4293NSpringfield Flying Service LLC · Columbia, CABuilt 1947 · S/N 13764N4293TDiehl Ryan J · Columbus, OHS/N 7AC5466N4293UKelly Reginald David · Morehead City, NCBuilt 1964 · S/N 15060293N4294CBaldwin Stephen A · Olalla, WABuilt 1948 · S/N NAV-4-1653N4294VDekryger John · Fremont, MIBuilt 1948 · S/N 18652N4295EKaushagen Luther G · Thief River Falls, MNBuilt 1947 · S/N 7BCM-420N4295LBravo Aviation LLC · Rexburg, IDBuilt 1966 · S/N 17254364N4296FMargraf Todd R · Miamisburg, OHBuilt 1958 · S/N 46196N4296LBreidenbach Todd J · Sabin, MNBuilt 1966 · S/N 17254365N4297EMccallum James W · Ambrose, GABuilt 1948 · S/N 11CC-169N4297UMondrik Michael R · Blessing, TXS/N 15060297N4298FGunn Sean · Colorado Springs, COBuilt 1958 · S/N 46198N42994Planes Of Fame Air Museum · Chino, CABuilt 1946 · S/N 15353N4299EViggiano Louis Jr · San Antonio, TXBuilt 1948 · S/N 7DC-113N4299FRomano Louis A · Middletown, NJBuilt 1958 · S/N 46199N4299NHogan Michael · Lansing, MIBuilt 1947 · S/N 13770N4299UJohnson Daniel P · Williamsburg, IAS/N 15060299N429PMSmith Craig W · Horton, MIBuilt 1967 · S/N 2N42BThomas Blake W · The Villages, FLBuilt 1942 · S/N 058B2692N42CDDunn Carrie B · Emporia, KSBuilt 1981 · S/N 1352N42DSBenet Ana R · Titusville, FLBuilt 1980 · S/N 428N42EFHaywas Luke R · Tucson, AZFirst renewal noticeS/N 118
Back to AD 94-05-05 R1