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.

N9163PMiller Richard Marc Trustee · Dana Point, CABuilt 1966 · S/N 24-4651N9166PNewman Jeffrey M · Pauline, SCBuilt 1966 · S/N 24-4654N9167PPegasus Unlimited LLC · Arroyo Grande, CABuilt 1966 · S/N 24-4655N9169PPorter Christina · Cape Coral, FLS/N 24-4658N9170PP&S Aviation LLC · White Rock, NMBuilt 1967 · S/N 24-4659N9171PMckim Thomas F · Winston Salem, NCBuilt 1967 · S/N 24-4660N9172PSale Reported · Henderson, NVSale reportedBuilt 1967 · S/N 24-4661N9175SMarshall Adam A · Fremont, NEBuilt 1967 · S/N 24-4664N9176PWalter Richard · Hampshire, ILBuilt 1967 · S/N 24-4665N9177PCochran Charles M III · Terre Haute, INBuilt 1967 · S/N 24-4666N9178PCarnes Harley · Ocean, NJBuilt 1967 · S/N 24-4668N9180PHughes Travis · Willow Park, TXBuilt 1967 · S/N 24-4670N9182PMonske Nicholas · Austin, TXS/N 24-4672N9184XContinental Title Trust LLC Trustee · Wichita, KSBuilt 1966 · S/N 30-1041N9187PJapundza Bob · Kokomo, INFirst renewal noticeS/N 24-4677N9188PRogermoser Hanspeter · Summerville, SCBuilt 1967 · S/N 24-4678N9189PThom Transport LLC · Marlette, MIBuilt 1967 · S/N 24-4680N918YInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 30736N9190PGreen Mark S · Ocala, FLBuilt 1967 · S/N 24-4683N9191ECatlin Aviation Co · Okla City, OKRegistration revokedBuilt 1959 · S/N 241538N9193PDean Aaron · Norwich, NYBuilt 1967 · S/N 24-4686N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689N9197PHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 24-4690N9198PBarna George · Castleton, NYBuilt 1967 · S/N 24-4692N91BRRegistration Pending · South Boston, VARegistration pendingBuilt 1965 · S/N 24-4326N91RGM&M Aviation LLC · Pelzer, SCBuilt 1958 · S/N 24-115N91XCFitzgerald David R · Canton, OHBuilt 1971 · S/N 39-90N9200PWings & Wheels Lease Of Central Nebraska LLC · Broken Bow, NEBuilt 1967 · S/N 24-4693N9205PDt Pralle Enterprise Inc · Hampton, IAS/N 24-4700N9207PWissler John H · Tenino, WABuilt 1967 · S/N 24-4702N9211PBordeleau Michael V · Bridport, VTS/N 24-4706N9212PHapka Leon J · Halma, MNFirst renewal noticeBuilt 1967 · S/N 24-4707N9216PWilliams Dayre · Red Cloud, NEBuilt 1967 · S/N 24-4712N9217PGruber Joachim R · Elizabethtown, KYFirst renewal noticeBuilt 1967 · S/N 24-4713N9219PChrastka Keith · San Angelo, TXBuilt 1967 · S/N 24-4715N921BLLewis Bertrand V · Glendale, AZBuilt 1964 · S/N 30558N9220PDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1967 · S/N 24-4716N9221PStevenson Tom · Portland, ORBuilt 1967 · S/N 24-4718N9222PAztec Remains LLC · Potosi, WIBuilt 1967 · S/N 24-4719N9224PAnde Leasing Co LLC · Edgewood, NMS/N 24-4721N9225PRegistered aircraftBuilt 1967 · S/N 24-4722N9227PSiebold Peter · Tehachapi, CABuilt 1967 · S/N 24-4717N9228PShillig Vance R · Colorado Springs, COS/N 24-4726N9229PKoeman Scott B · Fort Moore, GAS/N 24-4727N922JMApplied Aerospace Concepts Pllc · Bloomington, MNBuilt 1972 · S/N 24-5017N9231PSeaton Flying Services Inc · Salado, TXBuilt 1967 · S/N 24-4729N9233PBlandina Leon V · New Hudson, MIBuilt 1967 · S/N 24-4731N9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 24-4734N9236PTasso Aviation LLC · Orrville, ALS/N 24-4735
Back to AD 82-23-01 R1