AD 84-10-01 R1

Registered aircraft · 20,483

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:84-10-01-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:84-10-01-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.

N2752GZambarano Matthew C · South Hero, VTBuilt 1959 · S/N 52052N2752QAnspaugh Bruce E Trustee · La Crescenta, CABuilt 1967 · S/N 18257952N2753QFull Throttle Aviation LLC · Terlingua, TXS/N 18257953N2753XStorer Charles E · Payette, IDBuilt 1965 · S/N 18051553N2754FOtter Mark E · Warrensburg, MOBuilt 1965 · S/N 18256854N2755CR & B Aviation LLC · Oakland, MIBuilt 1955 · S/N 31902N2755QBlessed With Wings LLC · Queen Creek, AZS/N 18257955N2755XMcsheehy James B · Fallbrook, CABuilt 1965 · S/N 18051555N2756QLett Brian R · Eden Prairie, MNBuilt 1967 · S/N 18257956N2757FNationwide Web Directory Ltd · Seattle, WABuilt 1965 · S/N 18256857N2757QFive Seven Quebec Incorporated · Lake Stevens, WABuilt 1967 · S/N 18257957N2758XAerotechniques LLC · South Kent, CTBuilt 1965 · S/N 18051558N275DMMaxfield Douglas R · Chico, CABuilt 1975 · S/N 18052558N275FState Of Alaska Department Of Public Safety · Anchorage, AKS/N U20605207N275HPRich Aviation Services LLC · Fort Worth, TXBuilt 1976 · S/N 18265173N275PTTruss Travis D · Stephenville, TXBuilt 1997 · S/N 18280088N2761GMartinell Justin E · Dell, MTBuilt 1959 · S/N 52061N2762ADorman Richard E · Mesa, WABuilt 1957 · S/N 32849N2762FFreflite LLC · Wilmington, DEBuilt 1966 · S/N 18256862N2763FSeawings LLC · Holualoa, HIBuilt 1965 · S/N 18256863N2763XThompson Lyndon R · West Fargo, NDBuilt 1965 · S/N 18051563N2764QLong Donald G Jr · Gaston, ORBuilt 1967 · S/N 18257964N2765FStoup Lyndal K · Cordell, OKBuilt 1965 · S/N 18256865N2765XBa Aviation LLC · Anacortes, WAS/N 18051565N2766FBrach Raymond S · Henderson, NVBuilt 1966 · S/N 18256866N2766QThree Airmigos LLC · New Port Richey, FLBuilt 1967 · S/N 18257966N2767GBrowns Valley Aviation LLC · Utica, KYS/N 52067N2768GCarrion John H · Colusa, CABuilt 1959 · S/N 52068N2768XMullett James L · Mccall, IDBuilt 1965 · S/N 18051568N2769FMatthews George W · Hillsboro, OHBuilt 1965 · S/N 18256869N2769GFraser Kevin J · Snohomish, WABuilt 1959 · S/N 52069N2769KMillennium Air Inc · Maurice, IAS/N 18053064N2769QPrecision Truck Equipment Inc · Lansing, ILBuilt 1967 · S/N 18257969N276ACSmith Air Inc · Ukiah, CABuilt 1976 · S/N 21061442N276AKSalo Mark W · Poulsbo, WABuilt 1958 · S/N 50284N276CKHuckabee Charles J · Seadrift, TXBuilt 1982 · S/N R18201852N276MEBoersma Rances LLC · Warden, WABuilt 2000 · S/N 20608124N276TATextron Aviation Inc · Wichita, KSS/N 18283366N2770FEmmons Jack E · Elizabeth City, NCBuilt 1965 · S/N 18256870N2771GWhitt Sana F III · East Quogue, NYS/N 52071N2772XBratten Douglas D · North Pole, AKBuilt 1965 · S/N 18051572N2773FAdriatic Holdings LLC · Cheyenne, WYBuilt 1966 · S/N 18256873N2773XLee Ty K · Anchorage, AKBuilt 1965 · S/N 18051573N2774QRdj Brothers Trucking Inc · Bigfork, MTBuilt 1967 · S/N 18257974N2774XElk Creek Investments LLC · Helena, MTBuilt 1965 · S/N 18051574N2775FJock Carl A Trustee · Roscommon, MIBuilt 1966 · S/N 18256875N2775QRay Chris J · Ironside, ORBuilt 1967 · S/N 18257975N2776FBabovic Slobodan · Elm Grove, WIS/N 18256876N2776GOliver Charles D · Saint Albans, WVBuilt 1959 · S/N 52076N2776XSmith James A III · Millerton, NYBuilt 1965 · S/N 18051576
Back to AD 84-10-01 R1