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.

N93439Thomas Hunter David · Riverton, ILBuilt 1946 · S/N 762N93443Jefferts Erik W · Susanville, CAS/N 766N93448Bevis Richard L · Middletown, OHBuilt 1946 · S/N 771N93449N46p Inc · Fort Wayne, INBuilt 1946 · S/N 772N93452Ragan Dan M · Danbury, CTBuilt 1946 · S/N 775N93453Stevens Robert L · Ventura, CABuilt 1946 · S/N 776N93464Lopez Stephen D · Hopatcong, NJBuilt 1946 · S/N 787N93482Gilson David R · New Port Richey, FLBuilt 1946 · S/N 805N93494Johnson Harold C · Foster City, MIS/N 817N93498Van Nieuwenhuyzen Wesley G · Fremont, MIBuilt 1946 · S/N 821N93499Muise Leroy · Trenton, MEBuilt 1946 · S/N 822N93501Gbur Robert E · East Liverpool, OHBuilt 1946 · S/N 824N93506Grothe Wayne D · Veradale, WABuilt 1946 · S/N 829N93511Tabbert Charles · Diamondhead, MSS/N 834N93514Dalbey Joseph J · Urbandale, IABuilt 1946 · S/N 837N93515Braden James L · Hillsboro, KSS/N 838N93530Freeman Robert Dennis · Batavia, OHBuilt 1946 · S/N 853N93536Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 859N93539Spitfire Aviation Inc · Wilmington, DEBuilt 1946 · S/N 862N93542Popio John A · Marysville, OHBuilt 1957 · S/N 865N93543Hawkins Terry D · Conyers, GABuilt 1946 · S/N 866N93544Carlson James D · Hugo, MNS/N 867N93545Acock Danny J · Oklahoma City, OKBuilt 1946 · S/N 868N93553Poliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 876N93555Hess John C · Islip Terrace, NYBuilt 1946 · S/N 878N93569Traweek Parrish C · San Manuel, AZBuilt 1946 · S/N 892N93576Larson Daniel M · Fergus Falls, MNS/N 899N93584Godbold Joshua M · Perdido Beach, ALS/N 907N93587Paxton Ronald R · Colorado Springs, COBuilt 1946 · S/N 910N93598Boehler Brian S · Pacific City, ORBuilt 1946 · S/N 921N93606Vernon Gregory L · Swansea, SCBuilt 1946 · S/N 929N93610Treat Michael D · Fayetteville, ARBuilt 1946 · S/N 933N93611Vukonich Thomas P · Oxford, MIBuilt 1946 · S/N 934N93612Cook Sherman D · Mount Vernon, KYS/N 935N93614Peterson Dennis E · Cambridge, MNBuilt 1946 · S/N 3465N93616Casper Sean C · Oshkosh, WIBuilt 1946 · S/N 939N93636Schneider Scott M · Tribune, KSBuilt 1946 · S/N 959N93639Perkins Steven J · Herscher, ILBuilt 1946 · S/N 962N93654Sale Reported · Sherrill, ARSale reported, pending cancellationBuilt 1946 · S/N 977N93655Brosman Earl H · Indianapolis, INBuilt 1946 · S/N 978N93659Morrissett Jay D · Bumpass, VABuilt 1946 · S/N 982N93661Gonzales David J · Camarillo, CABuilt 1953 · S/N 984N93663Mcdaniel Michael K · Troy, VAFirst renewal noticeBuilt 1946 · S/N 986N93683Martin Daniel E · Longview, TXBuilt 1946 · S/N 1006N93684Mckenzie Kenneth E · Ft Lauderdale, FLBuilt 1946 · S/N 1007N93685Stuart Pat · Willow Springs, MOBuilt 1946 · S/N 1008N93687Registered aircraftBuilt 1946 · S/N 1010N93691Registration Pending · De Pere, WIRegistration pendingBuilt 1946 · S/N 1014N93694Nix Jimmie E · Madison, ALS/N 1017N93696Sale Reported · Locust Grove, GASale reported, canceledBuilt 1946 · S/N 1019
Back to AD 94-18-04 R1