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.

N3201CPilot John Consulting LLC · Vineyard, UTBuilt 1954 · S/N D-3854N3206LAlpha Tango LLC · Omaha, NEBuilt 1976 · S/N D-9951N3209CWellman Jared M · Weatherford, TXBuilt 1954 · S/N D-3869N320BFlorida Keys Aviation Service & Leasing LLC · Key Largo, FLBuilt 1957 · S/N D-5170N3211CJls Re Two LLC · Queen Creek, AZBuilt 1954 · S/N D3873N3211LPrevost Bryan · Lambert, MTBuilt 1976 · S/N D-9914N3214CDeaton Jeffrey D · Morehead City, NCBuilt 1954 · S/N D-3878N3215CGordon Clint M · New Port Richey, FLBuilt 1954 · S/N D3879N3216CKemp Jim M · St George, UTS/N D-3880N3217CCreative Commercial LLC · Puyallup, WABuilt 1954 · S/N D-3881N3219CMartin Daniel P · Mercersburg, PABuilt 1955 · S/N D-4161N321AAltman Mchael A · Austin, TXBuilt 1957 · S/N D-4962N321BValdez Aero Inc · Wilmington, DEBuilt 1957 · S/N D-4939N321BWAero Marine Inc · Westland, MIBuilt 1966 · S/N D-8343N321DSYoung Winston Shannon Jr · Del Rio, TXBuilt 1958 · S/N D-5661N321XVerrall Charles Peter Jr · Florence, AZS/N D-5990N3220CL00 Fliers LLC · Lewes, DES/N D-3884N3225CJames Sheldon Enterprises LLC · Ontario, OHBuilt 1954 · S/N D-3890N322HSReed Systems Ltd · Ellenville, NYBuilt 1974 · S/N D-9709N322NHBoyette Thomas E · Parker, COBuilt 1958 · S/N D-5646N322YGove Tyler A · Hoschton, GABuilt 1960 · S/N D-6351N3231CDigiacomo Jason T · Seaside, CABuilt 1954 · S/N D-3896N3232CBrooks Michael B · Tehachapi, CABuilt 1954 · S/N D-3897N3235CRegistration Pending · Louisville, TNRegistration pendingBuilt 1954 · S/N D-3900N323UShaneyfelt Samuel J · Shady Shores, TXBuilt 1966 · S/N D-8029N3240CMeves Transportation LLC · Kalispell, MTBuilt 1954 · S/N D-3905N3241CColvin Clu D DBA · Big Cabin, OKS/N D-3906N3244CTowery Daniel T · Dover, DES/N D-3909N3246CKrukow David M · Hampton, IABuilt 1954 · S/N D-3911N3247CIngold Terry · Albemarle, NCBuilt 1954 · S/N D-3912N3249CEscobar Alfredo · Canyon Country, CAS/N D-3914N324DBush David M · Englewood, COBuilt 1965 · S/N D-8016N324ESednal Enterprises · Los Gatos, CABuilt 1954 · S/N D-3908N324ZHannon Jim H · Cumming, GABuilt 1960 · S/N D-6478N3250CHawn Terry J · Vine Grove, KYBuilt 1954 · S/N D-3915N3251CByler Allen R · Long Prairie, MNBuilt 1954 · S/N D-3916N3252CSw Plains Aviation LLC · Ford, KSBuilt 1954 · S/N D-3917N3255CWills John L · Jasper, ALBuilt 1954 · S/N D-3920N3258CJohnson Clayton D · Sherwood, ORBuilt 1954 · S/N D-3923N3259CSanders John B · Knoxville, TNBuilt 1954 · S/N D-3925N325MGLock N Climb LLC · Independence, KSBuilt 1977 · S/N D-9990N3262CSievers Gilbert H · Medina, OHBuilt 1954 · S/N D-3928N32631Grewell Dean R · Waukee, IABuilt 1979 · S/N D-10301N3264CDevore John A C · Marion, OHS/N D-3930N3265CMahon Paul · Reston, VABuilt 1954 · S/N D-3931N3266CRegistered aircraftBuilt 1954 · S/N D-3932N3267CHoffman Paul Kevin · Chatsworth, GAFirst renewal noticeBuilt 1954 · S/N D-3933N3269CMiedema James D · Sandwich, ILS/N D-4184N326SCuruchet Shay · Kaycee, WYBuilt 1969 · S/N D-9067N3271CMugleston Tim H · Waldport, ORBuilt 1954 · S/N D-3937
Back to AD 94-20-04 R2