AD 94-05-05 R1

Registered aircraft · 26,232

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.

N7829EHochstatter Pat J · Moses Lake, WAFirst renewal noticeBuilt 1959 · S/N 17629N7829TDampier William · Greenwood, INBuilt 1960 · S/N 47429N7829XObservation Corp · Newark, CABuilt 1961 · S/N 17248329N7829ZMclaughlin Dustin T · Abilene, KSBuilt 1963 · S/N 15059929N78300Plane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 2300N7830TWalker Homes LLC · Stratford, OKBuilt 1960 · S/N 47430N7830UObrien Cornelius R · Sellersville, PABuilt 1964 · S/N 17251830N7830ZFlanary Kenneth Mitchell · Five Points, ALBuilt 1963 · S/N 15059930N78310Huang Sophie M · Newcastle, WABuilt 1946 · S/N 2310N78311Rey Henry R · Fresh Meadows, NYS/N 2311N78314Stinton Jacob Merle · Palmetto, FLBuilt 1948 · S/N 2314N78315Breese William R · Omaha, NEBuilt 1948 · S/N 2315N78316Christiansen Lance W · Anacortes, WABuilt 1947 · S/N 2316N78317Silveria Frank R · Los Banos, CABuilt 1946 · S/N 2317N7831AZollitsch Allan P · Lancaster, NYBuilt 2017 · S/N 3930N7831FHallmark Ryan M · Vidor, TXBuilt 1966 · S/N 15063931N7831UHerrin Thomas · Patterson, GABuilt 1964 · S/N 17251831N7831XChupka Kris W · Golden, COBuilt 1961 · S/N 17248331N78320Zoom Leasing LLC · Barto, PABuilt 1948 · S/N 2320N78321Yak Training LLC · Mansfield, TXS/N 2321N78324Langman Greg K · Manitowoc, WIBuilt 1948 · S/N 2324N78325Dooley David C · Erie, COBuilt 1948 · S/N 2325N78326Gregg Delvin K · Durango, COBuilt 1948 · S/N 2326N78328Bucklar Construction Co · La Quinta, CAS/N 2328N7832TN7832t LLC · Wilmington, DEBuilt 1960 · S/N 47432N7832UFly 32u LLC · Monroe, NCBuilt 1964 · S/N 17251832N7832ZArnold Mark D · Holloway, MNS/N 15059932N7833EChecky Allan O Jr · Merrimac, WIBuilt 1959 · S/N 17633N7833MFoote Lori A · Decherd, TNBuilt 1960 · S/N 17247978N7833TJohnson Spring M · Wortham, TXBuilt 1960 · S/N 47433N7833ULfs Inc · Gillette, WYBuilt 1964 · S/N 17251833N7834TYturri David P · Marble Falls, TXBuilt 1960 · S/N 47434N7834USirens Call LLC · Nashville, TNBuilt 1964 · S/N 17251834N7834ZRall Jared W · Williamsport, PABuilt 1963 · S/N 15059934N7835EUnternaehrer Robert U Trustee · Brunswick, MOBuilt 1959 · S/N 17635N7835JCornwell Jerry T · Mc Alpin, FLBuilt 2018 · S/N 061N7835TRound Engine Aero · Nashville, MIBuilt 1960 · S/N 47435N7835UEyrie Aviation LLC · Suwanee, GAFirst renewal noticeBuilt 1964 · S/N 17251835N7836KKennedy Brent Robert · Anchorage, AKBuilt 1952 · S/N 20631N7836XOsage Aviation LLC · Yates Center, KSS/N 17248336N7836ZSpartan National Holdings LLC · Missoula, MTBuilt 1963 · S/N 15059936N7837FObrien Daniel N Jr · Bellevue, WABuilt 1973 · S/N A1500450N7837UCommander Aviation LLC · Monroe, MIBuilt 1964 · S/N 17251837N7837ZBouvier Louis M III · Monticello, UTFirst renewal noticeBuilt 1963 · S/N 15059937N7838FMcdonald Air Services LLC · Saint Johns, MIBuilt 1966 · S/N 15063938N7838ZMonnig Hans J · Westerville, OHBuilt 1963 · S/N 15059938N7839XBedsole Jerry L · Elba, ALBuilt 1961 · S/N 17248339N7840UKay Bennie L · Brigham City, UTBuilt 1964 · S/N 17251840N7840ZHorak Mark E · Valencia, CABuilt 1963 · S/N 15059940N78416Sands Donald · Lafayette, LAS/N 23157
Back to AD 94-05-05 R1