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.

N7159PAdams George D · Franklin, INFirst renewal noticeBuilt 1960 · S/N 24-2325N7159YPepmiller Scott C · Panama City Beach, FLS/N 30-177N7161PMaurer Bruce C · Power, MTBuilt 1960 · S/N 24-2327N7163YBoyd John W · Milton, WABuilt 1963 · S/N 30-184N7164YGreat Lakes Air Ventures LLC · Mason, MIBuilt 1963 · S/N 30-185N7166YCollum Aviation LLC · Milton, FLBuilt 1963 · S/N 30-187N7167YThomas Thomas J · Lewisburg, WVBuilt 1963 · S/N 30-188N7168PSchober Brian S · Scottsdale, AZBuilt 1960 · S/N 24-2336N7170PDalton Dennis P · Walsenburg, COBuilt 1960 · S/N 24-2338N7171YHeinrich Steven W · Conroe, TXBuilt 1963 · S/N 30-191N7172PBarksdale Kevin L · Moore, OKBuilt 1960 · S/N 24-2340N7175PNewton Roger N Jr · Marerro, LABuilt 1960 · S/N 24-2344N7177POverstreet Robert S · Clarksville, VABuilt 1964 · S/N 24-3635N7178PN9271p LLC · Pahrump, NVBuilt 1960 · S/N 24-2347N7179PHedgpeth H Brent · Bothell, WABuilt 1960 · S/N 24-2348N717TATwin C Aviation Inc · Chapel Hill, NCBuilt 1966 · S/N 30-1030N7180P352 Aviation LLC · Clermont, FLBuilt 1960 · S/N 24-2349N7180YAl-Banna Emad R · Huntingtown, MDBuilt 1963 · S/N 30-200N7181PStrydom Cornelis F · Liberal, KSS/N 24-2350N7182YMccue John M · Tuttle, OKS/N 30-206N7183KRabourn John P · Spokane, WABuilt 1963 · S/N 30-207N7184PWilson Brian E · Lecanto, FLBuilt 1960 · S/N 24-2354N7185PMack Darryl T · Matteson, ILBuilt 1960 · S/N 24-2355N7186YHill Mark T · Gloucester, VAS/N 30-210N7187YAircore LLC · Apache Junction, AZBuilt 1963 · S/N 30-211N7188PBackcourse Flyers Inc · Powell, TNS/N 24-2358N7188YRegistration Pending · Christiansted, VIRegistration pendingBuilt 1963 · S/N 30-212N7189PTofan Ray · National City, CABuilt 1960 · S/N 24-2359N7189YHesano Joseph M · Rockford, ILBuilt 1963 · S/N 30-213N718JRFlytwincos LLC · Las Vegas, NVBuilt 1964 · S/N 30-276N7190YMiller Kevin · Collegedale, TNBuilt 1963 · S/N 30-214N7191PRamineni Raja · Fort Mill, SCBuilt 1961 · S/N 24-2361N7192PBest Equipment Leasing LLC · Bakersfield, CABuilt 1960 · S/N 24-2362N7193PSzczawinski Anthony J · Elko, NVFirst renewal noticeBuilt 1960 · S/N 24-2363N7196YAircraft & Aviation Professionals LLC · Coldwater, MIS/N 30-220N7199PLee Jeffrey L · Cameron, MTBuilt 1961 · S/N 24-2370N7199YFour Way Aircraft Ltd · Pensacola, FLBuilt 1963 · S/N 30-223N71ADSons Aviation LLC · Moody, ALS/N 30-1524N71BBMitchell Trans · Timnath, COFirst renewal noticeBuilt 1967 · S/N 30-1539N71GMEtheredge Mark · Pell City, ALBuilt 1969 · S/N 30-1959N71GTHazduff LLC · Plainfield, INBuilt 1969 · S/N 30-1801N71PVCeleste LLC · Playa Del Rey, CABuilt 1966 · S/N 30-1261N7200PThompson Grover A · Locust, NCBuilt 1960 · S/N 24-2386N7200YBroussard Don W Jr · Wynne, ARBuilt 1963 · S/N 30-224N7203PGorge Fast Aviation LLC · Hood River, ORBuilt 1960 · S/N 24-2373N7204PPittner Hans C · Goshen, NYBuilt 1960 · S/N 24-2374N7206YSkyflite LLC · Hillsboro, ORS/N 30-232N7207PSteinbach Philipp · Bentonville, ARBuilt 1960 · S/N 24-2377N7209YThy Will Be Done Here LLC · Reno, NVBuilt 1963 · S/N 30-235N7210PBirdwell David W · Richmond, TXBuilt 1960 · S/N 24-2380
Back to AD 82-23-01 R1