AD 94-05-05 R1

Registered aircraft · 26,230

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.

N89816Redman Ronald G · Palouse, WABuilt 1946 · S/N 8865N89818Benning Dennis D · Tuolumne, CABuilt 1946 · S/N 8867N89829Ficker Duane · Marine, ILS/N 8878N89830Doda Scott R · Niagara, WIBuilt 1946 · S/N 8879N89833Shaffer Randall H · Orinda, CABuilt 1946 · S/N 8882N89835Ramras Jay B · Fairbanks, AKBuilt 1946 · S/N 8884N89836Barr Michael J · Colorado Springs, COBuilt 1946 · S/N 8885N89837Williams Robert W Jr · Lees Summit, MOBuilt 1946 · S/N 8886N8983BMcguire Zach T · Jasper, MOBuilt 1958 · S/N 36683N89842Welch James D · Holdenville, OKBuilt 1946 · S/N 8891N89844Stevens Brian R · Lompoc, CABuilt 1946 · S/N 8893N89848Haas David C · Janesville, WIS/N 8897N89849Myers Russell · Spangle, WABuilt 1946 · S/N 8583N8984BWhelchel Neil E · Joshua Tree, CABuilt 1958 · S/N 36684N89850Thompson Michael P · Natchez, MSBuilt 1946 · S/N 8584N89855Jones Riley T · Thayne, WYS/N 8900N89858Livingston Patrick A · Pratt, KSBuilt 1946 · S/N 8903N8985RChapman William H · Dayton, OHBuilt 1959 · S/N 7FC-350N8985SOrganization Of Black Aerospace Professionals · Westchester, ILBuilt 1965 · S/N 15062285N8986Fisher William G · Union City, GAS/N 1342N89860Bradley Charles R · Herod, ILFirst renewal noticeBuilt 1946 · S/N 8905N89861Hicks Bobby J · Horn Lake, MSBuilt 1946 · S/N 8906N8986SSchneider Jackson L · Florissant, MOBuilt 1965 · S/N 15062286N8986UJmt Aviation LLC · Bel Air, MDBuilt 1976 · S/N 15078036N8987BHoover Rowdy L · Owasso, OKBuilt 1958 · S/N 36687N89882Plane Fun Inc Tr Trustee · Snellville, GABuilt 1946 · S/N 8927N89883Beck Christopher A · Belvidere, ILS/N 8928N89884Valiair Lc Trustee · Casper, WYBuilt 1946 · S/N 8929N89885Erhart Aviation Services LLC · Kalispell, MTBuilt 1946 · S/N 8930N89886Dickson David C · Sebring, FLBuilt 1946 · S/N 8931N8988UQuestair LLC · Madison, MSBuilt 1976 · S/N 15078038N89895Gandall Ryan D · Elk, CAS/N 8940N89898Fay Gregory A · Milton, VTS/N 8943N89903Covey Zachary J · New Underwood, SDBuilt 1946 · S/N 8948N89906Beery Ray M · Exeter, CABuilt 1946 · S/N 8951N89907Hill David A · Fort Worth, TXBuilt 1946 · S/N 8952N8990BSortomme Jeffrey P · Sacramento, CABuilt 1958 · S/N 36690N89911Krause Aviation LLC · Geneva, ILBuilt 1946 · S/N 8960N89918Christie Ian A H · Limon, COBuilt 1946 · S/N 8967N89923Livermont Joann M · Dillingham, AKBuilt 1946 · S/N 8972N89925Dirigo Aerospace Solutions LLC · Sumner, MES/N 8974N89932Swartzendruber Brett · Hesston, KSS/N 8984N89936Barnes Clint R · Wills Point, TXBuilt 1946 · S/N 8988N89938Nickel Galen L · Sagle, IDBuilt 1946 · S/N 8990N8993SRopp Dale Arden · Bemidji, MNBuilt 1965 · S/N 15062293N89941Bernard E Fay II · Eagle, AKBuilt 1946 · S/N 8993N89942Hawgwild Aviation & Holdings LLC · Kansas City, MOBuilt 1946 · S/N 8994N89947Christain Keith · Ogden, UTBuilt 1946 · S/N 8999N8994SMorel Charles Paul IV · Morgan Hill, CABuilt 1965 · S/N 15062294N8994UWahlberg Randy A · Pearland, TXBuilt 1976 · S/N 15078044
Back to AD 94-05-05 R1