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.

N3704HBrown Terese A · Port Saint Lucie, FLS/N 4329N37119Hahola James J · Easton, PAS/N 86N37122Morgan Kenneth H · Carthage, NCBuilt 1941 · S/N 89N37129Eaa Chapter 1590 Inc · Morrilton, ARBuilt 1941 · S/N 96N37130Folk George W · Martinsburg, WVBuilt 1941 · S/N 97N37135Porter Bryan L · Kent, WABuilt 1941 · S/N 102N37139Bowers Robert D · Ottawa, KSBuilt 1956 · S/N 106N37140Perry John · Tomah, WIBuilt 1941 · S/N 107N37143Hardin John M · Terrell, TXBuilt 1941 · S/N 110N3714HMcnew Brooks C · Stevensville, MDBuilt 1946 · S/N 4339N3726HWinter Jack W · Custer, SDS/N 4351N3734HRobinson Stephen G · Livermore, CABuilt 1946 · S/N 4359N3761HBrezina Chad M · Whitewright, TXBuilt 1947 · S/N 4386N3769HBowers Dennis · Palacios, TXBuilt 1947 · S/N 4394N3771HGoldstein Steven I · Hawthorne, NJBuilt 1947 · S/N 4396N3773HDuvall Gene Adrian · Amarillo, TXBuilt 1947 · S/N 4398N3779HDurfee Robert W.C. · Taylor, MIS/N 4404N3793HHensley Michael F · Coos Bay, ORBuilt 1947 · S/N 4418N3794HWorley William M · Camden, NCBuilt 1947 · S/N 4419N3798HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4423N37JMLowe Ron C · Abernathy, TXBuilt 1946 · S/N 353N3807HBassett Robin · Orlando, FLBuilt 1947 · S/N 4508N3821HWilson Christopher W · Honey Grove, TXBuilt 1947 · S/N 4522N3831HBlickhan C John · Quincy, ILBuilt 1947 · S/N 4532N3834HStuder Rodney J · Shelby, MIS/N 4535N3835HMadden John J Trustee · Frostproof, FLS/N 4536N3838HHales Thomas P III · Venice, FLBuilt 1947 · S/N 4539N3852HPaxton Ronald R · Colorado Springs, COBuilt 1947 · S/N 4553N3864HHensley Michael · Coos Bay, ORBuilt 1947 · S/N 4565N3868HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4569N3869HPopio John A · Marysville, OHBuilt 1947 · S/N 4570N3870HGuenther Mary J · Port Charlotte, FLBuilt 1947 · S/N 4571N3878HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4579N3888HLewis James T Jr · Williamsport, MDS/N 4589N3893HCross Franklin O · Huntsville, MOS/N 4594N3906HKrall James M · Mitchell, SDBuilt 1947 · S/N 4607N3907HJones William G · Kent, WABuilt 1947 · S/N 4608N3913HDidier Thomas · Port Washington, WIBuilt 1947 · S/N 4614N3919HReed Tyrone P · Essexville, MIBuilt 1947 · S/N 4620N3922HWhite Wayne · Middleburg, FLBuilt 1947 · S/N 4623N3924HLanier Bertice L · Maple Hill, NCBuilt 1947 · S/N 4625N3926DGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4627N3927HPoliak Mark A Trustee · Carmel, INBuilt 1947 · S/N 4628N3943HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4644N3948HYordan Victor E · Simpsonville, SCBuilt 1947 · S/N 4649N3958HHoover Michael B · Ridgeland, WIBuilt 1947 · S/N 4659N3966HRokeby Richard F · Tulsa, OKBuilt 1947 · S/N 4667N3968HCannon Christopher C · Charleston, WVBuilt 1947 · S/N 4669N3969HAnderson Olie · Neola, UTBuilt 1947 · S/N 4670N3971HPerry Gregory C · Maurice, LABuilt 1947 · S/N 4672
Back to AD 94-18-04 R1