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.

N3728F316 Aviation LLC · Saint Clair Shores, MIBuilt 1966 · S/N 17255223N3728JSpo Aviation LLC · Eufaula, OKBuilt 1966 · S/N 15065028N3728LN3728l LLC · Statesville, NCBuilt 1965 · S/N 17253897N3728RRaks Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 17255528N3728V140 Ventures LLC · Lewes, DES/N 15005N37296Ballard Rickey G · Buckeye, AZBuilt 1941 · S/N 139N3729FPena Miguel A · Live Oak, FLS/N 17255224N3729LWells Timothy P · Raynham, MAS/N 17253898N372DRees Ryan G · Loa, UTS/N 15070466N372ECDienst Lon C · Poplar Grove, ILS/N 18N37304Bays Stuart B · Tyler, TXBuilt 1941 · S/N 147N3730EKoening John A · Boca Raton, FLBuilt 1947 · S/N 7AC-7021N3730RChief Joseph Flyers Inc · Joseph, ORBuilt 1966 · S/N 17255530N3730VSteingas David M · Karnack, TXBuilt 1949 · S/N 15007N3731KDicker Alan J · Scottsdale, AZBuilt 1946 · S/N 1424N3731LSturguess James K · Boonville, MOS/N 17253900N3731SHerzfeld-Van Dyke Holly A · Conway, ARBuilt 1963 · S/N 17250931N3732LSumma Dawn K · Medina, OHBuilt 1965 · S/N 17253901N3732SMccague Kelly M · Las Cruces, NMBuilt 1963 · S/N 17250932N3732VRosenbach Jay A · Chugiak, AKBuilt 1949 · S/N 15051N37335Love Kenneth Jay · CombaningBuilt 1941 · S/N 178N3733FBurch Samuel Owen · Roxboro, NCBuilt 1966 · S/N 17255228N3733LHillstrom Rudolph A · Oakville, WABuilt 1965 · S/N 17253902N3733RCouick Donald Michael · Monroe, NCBuilt 1966 · S/N 17255533N3733SBrn Technical Inc · Boca Raton, FLBuilt 1963 · S/N 17250933N3733VToccoa Aviation · Toccoa, GABuilt 1975 · S/N 15076605N3734HRobinson Stephen G · Livermore, CABuilt 1946 · S/N 4359N3734JTrue Course LLC · Honolulu, HIBuilt 1966 · S/N 15065034N3734VBurrell Dennis E · Parma, IDS/N 15076606N3735FEb Flight Training LLC · Daytona Beach, FLBuilt 1966 · S/N 17255230N3735JPetersen Kenton D · Jefferson, SDBuilt 1966 · S/N 15065035N3735KHarris George P · Pine, COBuilt 1946 · S/N 1428N3735SBeucler Brian G · Sandown, NHFirst renewal noticeBuilt 1963 · S/N 17250935N37361Pietsch Kent D · Burlington, NDBuilt 1941 · S/N 204N37369Northway Mathew W · Eugene, ORBuilt 1941 · S/N 212N3736EAvila Raul · Lakeland, FLS/N 7BCM-7027N3737VClarke Adrian N · Aledo, TXBuilt 1975 · S/N 15076607N37381Taylor Brent · Ottumwa, IABuilt 1941 · S/N 224N3738LTran Tuan M · Canton, MIBuilt 1965 · S/N 17253907N3738VPeirson Dana M · Carson City, NVBuilt 1948 · S/N 15015N3739FSchlueter Helmuth K · San Tan Valley, AZS/N 17255234N3739LMattson David G · Lake Park, MNBuilt 1965 · S/N 17253908N3739RRusak Robert J · Paris, TXBuilt 1966 · S/N 17255539N373ACCalvi Charles G · Berryville, VABuilt 2023 · S/N 21N373CSCook Kyle H · Newberry, FLBuilt 1946 · S/N 4524N373KVCrystalinas Johnathan · Rancho Cordova, CABuilt 1966 · S/N 15064401N374Harvey Donald W · Concord, NCBuilt 1958 · S/N 10N37403Pietsch Kent D · Burlington, NDBuilt 1942 · S/N 246N37406Lander David W · Gilroy, CABuilt 1942 · S/N 249N3740FLavalley Asset Management · Potsdam, NYBuilt 1966 · S/N 17255235
Back to AD 94-05-05 R1