OpenAirDocs.org
AD 82-23-01 R1

Registered aircraft · 3,118

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:82-23-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:82-23-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.

N7593PWaitkus James M · Oak Park, CABuilt 1961 · S/N 24-2804N7593YEpic Aviation Leasing LLC · Puyallup, WABuilt 1965 · S/N 30-662N7596YRodgers Kevin M · Vacaville, CAS/N 30-665N7597PSpinks Matthew Robert · Clarkesville, GAS/N 24-2808N7598PBurton Channing L · League City, TXBuilt 1961 · S/N 24-2809N75HDMorton Michael E · Hickory, NCS/N 30-757N7600YSchell Joseph H · Granbury, TXBuilt 1964 · S/N 30-669N7601YMines Keith A · White Cloud, MIBuilt 1964 · S/N 30-671N7602PBischoff Brent J · Bandon, ORBuilt 1961 · S/N 24-2813N7604YHennum Gretchen I · Eagle, COBuilt 1965 · S/N 30-675N7605PKienle Richard L · Weatherford, TXBuilt 1968 · S/N 24-2816N7605YPlane Care LLC · Tucson, AZBuilt 1964 · S/N 30-676N7608YJohnson Craig · Moreland, GAS/N 30-679N7609YDowning Gregg R · Guymon, OKBuilt 1964 · S/N 30-680N7610PMorris Scott R · Steilacoom, WABuilt 1961 · S/N 24-2821N7611PChamberlain Paul E · Troup, TXBuilt 1961 · S/N 24-2822N7611YRandall Dean A · Reno, NVS/N 30-683N7613PSimpson Randolph L · Shelburne Falls, MABuilt 1961 · S/N 24-2824N7614YSky Walker Flight School LLC · Adrian, MIBuilt 1964 · S/N 30-687N7615PFly High Ventures LLC · Chester, VABuilt 1961 · S/N 24-2826N7616PNelson Peter T · Ghent, NYBuilt 1961 · S/N 24-2827N7617PSlack Don S · Stinson Beach, CABuilt 1961 · S/N 24-2828N7618PJaton Bertrand F · Woodville, TXBuilt 1961 · S/N 24-2829N7619PFirst Class Auto Remarketing LLC · Lehigh Acres, FLS/N 24-2830N7621EGrey Matter Inc · Valley Springs, CAS/N 24-2168N7621PMckusick Eileen D · Winooski, VTBuilt 1961 · S/N 24-2832N7625PVfr2imc LLC · Elko, NVBuilt 1961 · S/N 24-2836N7626PZervos Fredric W · Orland Park, ILBuilt 1961 · S/N 24-2548N7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeS/N 30-700N7627PKill Stephen W · Granbury, TXBuilt 1961 · S/N 24-2837N7628YLamantia Mark V · Ebensburg, PABuilt 1964 · S/N 30-703N7630YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-706N7631YMbsp Enterprises Inc · Wilmington, DEBuilt 1965 · S/N 30-707N7632YLee Kitchell · Shelburne Falls, MAS/N 30-709N7633YMatt Younkin Airshows Inc · Siloam Springs, ARBuilt 1965 · S/N 30-710N7634PDykema Carl F · Davie, FLBuilt 1961 · S/N 24-2846N7637PFyi Adventures LLC · Ocala, FLBuilt 1962 · S/N 24-2849N7638YScientific Motive Systems Inc · Charlevoix, MIBuilt 1965 · S/N 30-717N7639YCaviris Homestead Farm LLC · Rollinsford, NHBuilt 1965 · S/N 30-718N7642PCollins Daniel R · Klamath Falls, ORBuilt 1961 · S/N 24-2856N7644PWhobrey Andrew · Bee Spring, KYBuilt 1961 · S/N 24-2858N7645YN7645y LLC · Sheridan, WYBuilt 1966 · S/N 30-1236N7648YFingerlakes Wing And Rotor LLC · Seneca Falls, NYBuilt 1965 · S/N 30-726N7652POso Air LLC · Missoula, MTBuilt 1961 · S/N 24-2734N7652YMetro West Ambulance · Hillsboro, ORBuilt 1965 · S/N 30-730N7653PThomason Tony L · Williamson, GABuilt 1961 · S/N 24-2703N7656PAnkney Gary L · Rector, PABuilt 1961 · S/N 24-2869N7660PRegistered aircraftBuilt 1961 · S/N 24-2873N7662PRemund Richard W · Slate Hill, NYBuilt 1961 · S/N 24-2875N7664PSandpiper Aviation LLC · Carson City, NVBuilt 1961 · S/N 24-2877
Back to AD 82-23-01 R1