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.

N8891YGreat Plains Aero Inc · Iowa City, IABuilt 1970 · S/N 39-49N8892PN8892p LLC · Glendale, AZBuilt 1965 · S/N 24-4345N8894PGarms Walter I III Trustee · Berkeley, CABuilt 1965 · S/N 24-4347N8895YRegistered aircraftS/N 39-52N8897PFey Ray D · Middleton, WIBuilt 1965 · S/N 24-4351N8897YAvion LLC · Lewes, DEBuilt 1970 · S/N 39-54N8898YWickenheiser Kenneth W · Sun City, AZBuilt 1970 · S/N 39-33N8899PLavoie Paul · Macon, GAS/N 24-4353N88APLangdon Brian B · Newcastle, WABuilt 1964 · S/N 30-456N88FVandivort Aaron · Jacksonville, FLBuilt 1959 · S/N 24-1245N88WWQwest Aviation LLC · Edwardsburg, MIBuilt 1971 · S/N 39-125N8900PCabrejos-Guillen Roberto · Wichita, KSBuilt 1965 · S/N 24-4355N8901PRead Robert S · Peoria, AZBuilt 1966 · S/N 24-4356N8902PFarris Greg T · Ann Arbor, MIBuilt 1966 · S/N 24-4357N8903PBeyer Marvin A Jr · Taft, TXBuilt 1966 · S/N 24-4358N8903YBall Half Out LLC · Mesa, AZBuilt 1970 · S/N 39-58N8905PBulle Jason L · Phoenix, AZBuilt 1966 · S/N 24-4360N8906PComanche Inc · Leoti, KSBuilt 1966 · S/N 24-4361N8906YRegistered aircraftBuilt 1970 · S/N 39-61N8910PComanche LLC · Peachtree City, GABuilt 1966 · S/N 24-4365N8911PVarga Craig S · Chino Valley, AZBuilt 1966 · S/N 24-4366N8912PPotts John L · Enterprise, ALBuilt 1966 · S/N 24-4367N8914YHarris William M · Christiansburg, VABuilt 1970 · S/N 39-71N8915PLegacy Aviation Mid-Michigan LLC · Kalamazoo, MIBuilt 1966 · S/N 24-4370N8917PLogsdon James C · Hanford, CABuilt 1966 · S/N 24-4372N8917YHigh Flyers Inc · Jackson, TNBuilt 1970 · S/N 39-76N8919PHealey Patrick T · Tucson, AZBuilt 1966 · S/N 24-4374N891MDCharbonneau John E · Manhattan, KSBuilt 1960 · S/N 24-2045N8921POwens Gregory E · Kendallville, INBuilt 1966 · S/N 24-4377N8924YPrestininzi Robert Anthony · Fort Mill, SCBuilt 1969 · S/N 30-1997N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381N8925YBlue Sky Adventures LLC · Hanover, PAS/N 39-81N8926PGallagher Derek P · O Fallon, ILS/N 24-4382N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384N892RCSmw-Cjh Corp · Wilmington, DEBuilt 1966 · S/N 24-4379N8931PDuncan Michael J · Cordova, TNBuilt 1966 · S/N 24-4387N8932P260b LLC · San Diego, CABuilt 1966 · S/N 24-4388N8934PNermernuh LLC · Chester, CTBuilt 1966 · S/N 24-4390N8934YFuller John M · Minden, NVBuilt 1971 · S/N 39-95N8936PGesenhues Bernard J · Canton, OHBuilt 1966 · S/N 24-4392N8938YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1971 · S/N 39-99N8940PDavie Andrew S · Stony Point, NYBuilt 1966 · S/N 24-4396N8942PAncelet Grant D · Crowley, LABuilt 1966 · S/N 24-4398N8944PPittner Hans C · Goshen, NYBuilt 1966 · S/N 24-4400N8944YTallman Michael Daniel · Latrobe, PABuilt 1971 · S/N 39-105N8945YPipers Are Still Better LLC · Carson City, NVS/N 39106N8946PBreding Ralph E · American Falls, IDBuilt 1966 · S/N 24-4402N8947YStroh Chuck · Yukon, OKBuilt 1971 · S/N 39-108N8948YKilpatrick Kerry · Somerset, NJBuilt 1971 · S/N 39-109N8951PJames Donnie E · Collinsville, ALBuilt 1966 · S/N 24-4408
Back to AD 82-23-01 R1