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.

N1WUN1wu LLC · Loganville, GABuilt 1966 · S/N 30-1383N1WYBultron Cristina · Ocala, FLBuilt 1964 · S/N 24-4018N1XACowell Aviation Maintenance LLC · Easley, SCBuilt 1964 · S/N 24-3599N200DBDelta Bravo Inc · Davie, FLBuilt 1959 · S/N 24-1080N2024PYounhorsh Sales LLC · Wilmington, DEBuilt 1956 · S/N 24-1N203SCWesley Robert J · Chuckey, TNBuilt 1966 · S/N 30-1118N204WTRegistered aircraftBuilt 1964 · S/N 30-699N206RGVne LLC · Dowagiac, MIBuilt 1967 · S/N 30-1427N208RGInland Northwest Aero LLC · Veradale, WABuilt 1966 · S/N 30-1152N20RDickerson Stephen R · Frisco, TXBuilt 1960 · S/N 24-1684N212GPWibel Enterprises Inc · Crossville, TNS/N 24-3327N212RGGillum Reef · Clint, TXBuilt 1962 · S/N 24-3123N214JNFox-1 Drafting & Design Inc · Eagan, MNBuilt 1966 · S/N 30-1130N2172MPacker Bruce P Trustee · Tempe, AZBuilt 1963 · S/N 24-3305N217HCSwartzendruber Brett E · Hesston, KSBuilt 1963 · S/N 30-166N218SAInternational Air Services Inc Trustee · Carson City, NVS/N 24-1877N21PAHensley Aviation LLC · Telford, TNS/N 30-1255N221DFMoeckel Herbert R · Tunas, MOBuilt 1958 · S/N 24-242N2222ZParsons John C · Wichita, KSBuilt 1963 · S/N 24-3388N222HLDouble K Flying LLC · Scottsboro, ALBuilt 1961 · S/N 24-2670N2235WSamuels Walter E · Wilmington, NCBuilt 1969 · S/N 30-1844N224KJam Three LLC · St George, UTBuilt 1959 · S/N 24-1609N2255YShogren Scott F · Fort Pierce, FLS/N 30-1268N2268YMohr Marcia L DBA · New Richmond, WIBuilt 1964 · S/N 30-544N226MAdams Larry Gene · Parker, AZBuilt 1960 · S/N 24-2326N228FPRegistered aircraftS/N 24-2538N229TYSchilling Aviation LLC · Britton, MIBuilt 1962 · S/N 24-3339N22CJCleveland Adam · Abilene, TXBuilt 1965 · S/N 30-905N22LMRd Aire LLC · Opelika, ALBuilt 1963 · S/N 30-56N22SGAir Flight Enterprises Inc · South Daytona, FLS/N 30-1718N22TKGreen Theodore G · Franklin, WIBuilt 1963 · S/N 24-3541N230MJVne LLC · Sheridan, WYS/N 30-1302N230SWMartin Co · Tyrone, GABuilt 1971 · S/N 39-37N232YPGill Joshua Daniel · Tucson, AZS/N 24-3401N234BGLangeland Thomas Arthur · San Antonio, TXBuilt 1965 · S/N 30-909N23BMAxiom Development And Consulting LLC · Atlanta, GABuilt 1959 · S/N 24-1118N23LGGist Thomas Hottel III · Little Rock, ARBuilt 1959 · S/N 24-832N23MGNewhall William G · Longmont, COBuilt 1971 · S/N 39-28N23RDRegistered aircraftS/N 30-469N240LHWitt Aaron K · Hooker, OKBuilt 1966 · S/N 30-1240N241JPNate Nelsen LLC · Enterprise, ALBuilt 1963 · S/N 30-241N2428PHill Tim E · Russellville, ARBuilt 1970 · S/N 39-64N2456PMc Elheny Michael J · Canton, GABuilt 1962 · S/N 24-3153N245MWArment Christopher · Aberdeen, SDBuilt 1967 · S/N 30-1502N246MWLandrum Stuart · Farmington, MOBuilt 1964 · S/N 30-678N24TEKurtz James F · Bethesda, MDBuilt 1970 · S/N 39-53N250CCAerodynamics Worldwide Inc · Wilmington, DEBuilt 1960 · S/N 24-1931N250GTComanche Golf Tango LLC · Clifton, VAS/N 24-2496N250LJCarew Aviation Inc · Appleton, WIBuilt 1964 · S/N 24-3393N250PCHerndon Timothy M · Kingston, OKBuilt 1959 · S/N 24-1133
Back to AD 82-23-01 R1