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.

N7834PRegistered aircraftBuilt 1962 · S/N 24-3054N7834YBall Half Out LLC · Mesa, AZBuilt 1965 · S/N 30-911N7835YRegistration Pending · Lewes, DERegistration pendingBuilt 1965 · S/N 30-912N7836PKearney Kory · Papillion, NEBuilt 1962 · S/N 24-3056N7837PMobbd LLC · Vero Beach, FLS/N 24-3057N7840YArno Philip A · Clarence Center, NYBuilt 1965 · S/N 30-920N7842PFall Stuart W · Holland, MIBuilt 1962 · S/N 24-3065N7844PTroy Watson Consulting Inc · Muleshoe, TXBuilt 1962 · S/N 24-3067N7845PRawlins Everett R · Pedro, OHBuilt 1962 · S/N 24-3068N7848PJads Airplane Club LLC · Boyne City, MIBuilt 1962 · S/N 24-3071N7852YBordlemay John J · Lewisberry, PABuilt 1965 · S/N 30-932N7855YParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1965 · S/N 30-936N7856YEastern Technical Corp · Martinsburg, WVBuilt 1965 · S/N 30-937N7858YGraham Stuart H · Heath, OHBuilt 1965 · S/N 30-778N7860PValley Aircraft Management Inc · Visalia, CABuilt 1962 · S/N 24-3083N7861PSparks James R · Maxwelton, WVBuilt 1962 · S/N 24-3085N7861Y7861y LLC · Long Beach, CAS/N 30-942N7862YSteiger Michael P · Cypress, TXBuilt 1965 · S/N 30-944N7863PMicheletti Joe A · Lake Almanor, CABuilt 1962 · S/N 24-3088N7863YSlipshod Aviation LLC · Hurricane, UTBuilt 1965 · S/N 30-945N7864YVavra Loren · Phoenix, AZFirst renewal noticeBuilt 1965 · S/N 30-946N7865PGear Down Hangar LLC · Phoenix, AZBuilt 1962 · S/N 24-3090N7865YMussman Craig L · Grant Park, ILBuilt 1965 · S/N 30-948N7866PGcsb Enterprises LLC · Oklahoma City, OKBuilt 1963 · S/N 24-3091N7866YHenrie Aviation LLC · Fairfield, NJBuilt 1965 · S/N 30-949N7871YDow Jeff W · Port Hadlock, WAS/N 30-955N7873PKirtley Kevin R · Boise, IDBuilt 1962 · S/N 24-3099N7875P3 Commanches Aviation LLC · Williamston, SCBuilt 1962 · S/N 24-3101N7875YDodson Carl F · Jasper, INBuilt 1965 · S/N 30-959N7876PCrouse Gregory T · Napa, CABuilt 1962 · S/N 24-3102N7877PMiller Kenneth · Jennings, LAS/N 24-3103N7879PKeenan Matthew J · Clearwater, FLBuilt 1962 · S/N 24-3105N787ANDixon Richard W · Laytonsville, MDBuilt 1962 · S/N 24-3308N787KSWalden Franklin S · Southern Pines, NCBuilt 1964 · S/N 24-3644N7882PWaters Robert D · Albuquerque, NMBuilt 1962 · S/N 24-3110N7883PFinke Michael C · Pleasant Prairie, WIBuilt 1962 · S/N 24-3111N7883YHoward Jerry W · Snellville, GABuilt 1965 · S/N 30-968N7885YKregel Steven · Garnavillo, IABuilt 1965 · S/N 30-970N7887P7887papa LLC · Glenwood Springs, COBuilt 1962 · S/N 24-3116N7887YAskins Jack C · Wichita Falls, TXBuilt 1966 · S/N 30-973N7888YBurkel Robert G · Hemet, CABuilt 1966 · S/N 30-975N7890YMhr Leasing LLC · Hickory Corners, MIBuilt 1966 · S/N 30-977N7891PN7891p Partners LLC · Suffolk, VABuilt 1962 · S/N 24-3120N7892YHarrison Richard J · South Hamilton, MABuilt 1966 · S/N 30-979N7893PBas Part Sales LLC · Greeley, COS/N 24-3122N7893YRegistered aircraftBuilt 1966 · S/N 30-980N7898PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301873N7898YPatry Aeronautical Institute · Kalispell, MTBuilt 1966 · S/N 30-986N78PWPower Joe D · Seguin, TXBuilt 1963 · S/N 24-3434N78RJUsaeroflight LLC · Greenville, SCBuilt 1970 · S/N 39-21
Back to AD 82-23-01 R1