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.

N6969PHart Richard W · Alexandria, VABuilt 1960 · S/N 24-2111N696PGreer James E Jr · Summit Point, WVBuilt 1960 · S/N 24-1718N6974PLiske Robert R · Chesterfield, MIBuilt 1960 · S/N 24-2116N6978PGallego Victor · Matawan, NJBuilt 1960 · S/N 24-2121N6981PShakis Bear LLC · O Neill, NEBuilt 1960 · S/N 24-2124N6982PCapuano Group Inc · Ormond Beach, FLBuilt 1960 · S/N 24-2125N6983PRegistration Pending · Branchburg, NJRegistration pendingBuilt 1960 · S/N 24-2126N6984PEnglish John H · Pittsburg, TXBuilt 1960 · S/N 24-2127N6985PDull Stephen A · Redkey, INBuilt 1960 · S/N 24-2128N6988PKubitz Wesley M · Laurel, MTBuilt 1960 · S/N 24-2131N6994PHunt Ray A · Louisburg, NCBuilt 1960 · S/N 24-2137N6995PInternational Air Services Inc Trustee · Carson City, NVBuilt 1960 · S/N PA-24-2138N6996PWelling Charles E III · West Islip, NYBuilt 1960 · S/N 24-2139N69PDDemray William S · Northville, MIBuilt 1960 · S/N 24-1377N69RDKrens Janet E · Purcellville, VABuilt 1963 · S/N 30-183N6YLHolman Leasing LLC · Anchorage, AKS/N 301162N6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 30-572N7000YSlowpoke Air LLC · Palm Harbor, FLBuilt 1966 · S/N 30-1188N7001PPavlusik Tibor · Fort Mill, SCS/N 24-2146N7002PMonterey Bay Aviation Inc · Watsonville, CABuilt 1960 · S/N 24-2147N7003PAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 24-2148N7007PAden Charles L · Hudson, COBuilt 1960 · S/N 24-2151N7008YHeather Jordan Flying Services LLC · Port Saint Lucie, FLBuilt 1963 · S/N 30-9N700KRStrange Jim · Tyler, TXBuilt 1963 · S/N 30-52N7010PJuliett Tango LLC · West Rutland, VTBuilt 1960 · S/N 24-2154N7010YBrown William C Jr · Northville, MIBuilt 1963 · S/N 30-11N7011PJapikse Bert · Pawleys Island, SCBuilt 1960 · S/N 24-2156N7012YBooher Greg F · Livingston, TNBuilt 1963 · S/N 30-13N7013PShumock Craig A · Moss Point, MSS/N 24-2159N7013YHubbard James E · Dover, OHS/N 30-14N7014PRyan John David · Fort Rucker, ALBuilt 1960 · S/N 24-2162N7016PSgroi Eric A · Wentzville, MOS/N 24-2163N7017PDewey J Levie P C · Chino Valley, AZBuilt 1960 · S/N 24-2164N7017YMccormick Royce DBA · Seminole, TXBuilt 1963 · S/N 30-18N7020YMehrhoff Stanley E · Prairie Home, MOBuilt 1963 · S/N 30-21N7021YShira William G · Savannah, GABuilt 1963 · S/N 30-22N7023YMaki Stephen B · New Port Richey, FLBuilt 1963 · S/N 30-24N7024YAnderson David J · Gardnerville, NVBuilt 1963 · S/N 30-25N7025PA Precious Life Flight LLC · Bend, ORBuilt 1960 · S/N 24-2171N7028PNorthern Cape Sea Farms LLC · Cape May, NJBuilt 1960 · S/N 24-2175N7028YAces High Aviation Corp · Pembroke Pines, FLS/N 30-29N7030PMartens And Wyatt Air Service LLC · North Platte, NES/N 24-2177N7031PTenkiller Flying Club · Tahlequah, OKBuilt 1960 · S/N 24-2178N7032PFast Twin LLC · Angola, INBuilt 1960 · S/N 24-2179N7032YBoonedocks LLC · Valley, ALBuilt 1963 · S/N 30-34N7036PPumphrey Vickie E · Devine, TXBuilt 1960 · S/N 24-2183N7038PDolby Richard C · Payson, AZBuilt 1960 · S/N 24-2185N7039PClark Ronald F · Mc Cool Junction, NEBuilt 1960 · S/N 24-2186N7042YMulti Engine Flight Time LLC · St George, UTBuilt 1963 · S/N 30-45N7044YMcneely Courtney L · Dallas, TXBuilt 1963 · S/N 30-47
Back to AD 82-23-01 R1