OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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-20-04-R2')
    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-20-04-R2')
  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.

N3350CBale Paul C · Louisville, TNBuilt 1955 · S/N D4016N3354C3 Points LLC · Comstock Park, MIS/N D-4020N3355CElkins Quentin D · Andersonville, TNBuilt 1955 · S/N D-4021N3358AWagner Richard L · Willis, TXBuilt 1969 · S/N D-9062N335BSmall & Co LLC · Omaha, NES/N D-4854N335JAAstrologo Joseph A Jr · Tullahoma, TNBuilt 1964 · S/N D-7576N335NMarple Scott D · Indianapolis, INBuilt 1964 · S/N D-7752N335TCSchnell Daniel · Sisters, ORBuilt 1966 · S/N D-8274N335VHolden Donald T · Cherokee, IABuilt 1980 · S/N D-10338N335ZCosse Harold C · Euless, TXBuilt 1960 · S/N D-6484N3362CCarter Shauna C · Reeds Spring, MOS/N D-4029N3363CColburn Wayne · The Sea Ranch, CABuilt 1955 · S/N D4030N3366CPorter Timothy D · Saint Cloud, MNS/N D-4033N336ZGoodman Michael R · New Brighton, PABuilt 1960 · S/N D-6489N3372CJohnson Scott L · Warrenton, GABuilt 1955 · S/N D-4039N3374VPalotas Anne M · Napa, CABuilt 1955 · S/N D-4042N3376CGrieshaber Paul M · Catawba, NCBuilt 1955 · S/N D-4043N3381CCarol Corp · Lincoln, NES/N D-4048N338ACTruesdell Ronald W · Edgewater, FLBuilt 1954 · S/N D-3832N338JFElkins Quentin D · Andersonville, TNBuilt 1957 · S/N D-5401N3390CMelton Jason F · Bennington, INBuilt 1955 · S/N D-4057N3393CKretzler Garrett A · Xenia, OHBuilt 1955 · S/N D-4060N3394CDobson International Parts Inc · Rantoul, KSS/N D-4061N3395CCarre Franki · Loveland, COBuilt 1955 · S/N D-4062N3396CMclenaghan Alvin N · Phoenix, AZS/N D-4064N33EBAllardice John M Jr · Seneca, SCS/N D-4046N33FSBvd Inc · Yates Center, KSBuilt 1974 · S/N D-9658N33FXDougfly Inc · Malibu, CAS/N D-10105N33HMSands Daniel N · Los Lunas, NMS/N D-5115N33HTGroove LLC · Afton, VABuilt 1965 · S/N D-7885N33JLJ L Flyers LLC · Orinda, CABuilt 1968 · S/N D-8764N33RGLawler Daniel · Republic, WABuilt 1956 · S/N D-4701N33VBVb313 LLC · Fort Myers, FLBuilt 1976 · S/N D-9899N33VHRegistered aircraftBuilt 1975 · S/N D-9803N33VSRare Eagle Aviation LLC · Westcliffe, COBuilt 1977 · S/N D-10071N3400BLinenfelser Charles · Hardy, VABuilt 1953 · S/N D-3638N3403BGoff Clinton · Rapid City, SDBuilt 1953 · S/N D-3641N3404BBlackketter Jeremy · Sahuarita, AZBuilt 1953 · S/N D-3642N3408BFaust William G · Novato, CABuilt 1953 · S/N D-3646N3409BChastain Gregory T · Midlothian, TXBuilt 1953 · S/N D-3647N340DN340dholding LLC · Allen, TXBuilt 1967 · S/N D-8642N340QGuetter Steven T · Lakeville, MNBuilt 1958 · S/N D-5486N3410BRentel Michael J · Milton, WIBuilt 1953 · S/N D-3648N3412BHuff James W · Argyle, TXBuilt 1953 · S/N D-3650N3413BGressett Gary L · Niceville, FLBuilt 1953 · S/N D-3651N3414BHoffman Paul Kevin · Chatsworth, GABuilt 1953 · S/N D-3652N3415BNorman Mac H · Bridgeport, NEBuilt 1953 · S/N D-3653N3417BWempe Henry J · Watsonville, CAS/N D-3655N341VTBelmont Leasing LLC · Gig Harbor, WABuilt 1964 · S/N D-7589N341ZMendoza Refugio · Fresno, CABuilt 1960 · S/N D-6510
Back to AD 94-20-04 R2