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.

N22373Roche Timothy P · Falls Church, VABuilt 2007 · S/N 18281928N2237GSmith Caleb · Beggs, OKBuilt 1958 · S/N 51537N2238CGorham Wendy J · Grand Rapids, MNBuilt 1953 · S/N 30538N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741N2239GPotter Cleve J · Fresno, CABuilt 1958 · S/N 51539N223BTMull David L · Kathleen, GABuilt 1978 · S/N R18200360N223EMKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282252N223HCG206 LLC · San Juan, PRBuilt 2006 · S/N 20608269N223LDGaston'S White River Resort Inc · Lakeview, ARBuilt 1965 · S/N U206-0493N223MEChem-Air LLC · Shreveport, LABuilt 2000 · S/N 18280746N223RJCline Larry J · Beeville, TXBuilt 1979 · S/N 18266850N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999N223TLZanghi Michael · Katy, TXBuilt 1971 · S/N 18260719N223WHPerrin James F · Bancroft, WIBuilt 1964 · S/N 18051355N2241RHappy Landings Aero LLC · Wilmington, DEBuilt 1968 · S/N T210-0391N2241SEdmondson James K · Lemoore, CABuilt 1976 · S/N 21061186N2242CCac Of Ar LLC · White Hall, ARBuilt 2000 · S/N 18280779N2242GNelson Mark · Fairbanks, AKBuilt 1958 · S/N 51542N2243CBelleville Livestock Market Inc · Belleville, PABuilt 1953 · S/N 30543N2244CSkywagon Aero LLC · Wilmington, DES/N 30544N2244TAmerican Elevator · Ruidoso, NMS/N R18200004N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754N2245CChesnut Lonnie R · Palmer, AKS/N 30545N2245GSkyair Express LLC · Overton, NVS/N 51545N2246RMontgomery Brian · Houston, TXBuilt 1968 · S/N T210-0396N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191N2247TYellow Jacket Flying Club Inc · Atlanta, GABuilt 2007 · S/N 18281934N2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeBuilt 1968 · S/N T210-0398N2249CHepburn Joseph · Towanda, KSBuilt 1953 · S/N 30549N2249GDelph Timothy M · Wasilla, AKBuilt 1958 · S/N 51549N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193N224ACSellers Scott R Trustee · Racine, WIBuilt 1978 · S/N R18200272N224ALAirborne Support Group LLC · Marion, MTBuilt 1963 · S/N 2050342N224EMFsm Aviation LLC · Edmond, OKS/N 18281350N224HThompson Dennis P · Spokane Valley, WABuilt 1956 · S/N 32649N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016N224PTLee Mark W · Blaine, MNS/N 18265572N2251GValentine Terence S · Glennallen, AKBuilt 1958 · S/N 51551N2251TGardner Bryan T · Rancho Cucamonga, CABuilt 1977 · S/N R18200007N2252CMickey Donald J · Albuquerque, NMBuilt 1953 · S/N 30552N2252GRutter Eric R · Anchorage, AKBuilt 1958 · S/N 51552N2252RStout Walt · White Hills, AZBuilt 1968 · S/N T210-0402N2252SSpider Lips Aviation LLC · Fischer, TXBuilt 1976 · S/N 21061196N2253CFoss David K · Anchorage, AKS/N 30553N2254CCook Charles Nicholas · Lakeside, TXBuilt 1953 · S/N 30554N2254GSorrels Robert S · Starkville, MSBuilt 1958 · S/N 51554N2256CCnd Aerospace Ltd · Telluride, COBuilt 1953 · S/N 30556N2257RCanales Jorge · Anthony, NMBuilt 1978 · S/N R18200582N2258JPluhar Darrin P · Ekalaka, MTBuilt 1979 · S/N T18803441T
Back to AD 84-10-01 R1