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.

N3783Midwest Fling Service Inc · Elgin, NEBuilt 1963 · S/N 24-3553N37HEBjbipbip Corp Trustee · Wilmington, DES/N 24-4514N3815EHonest Dog Farms LLC · Fayetteville, GABuilt 1966 · S/N 30-1335N38760Davis Robby E · Plant City, FLBuilt 1969 · S/N 30-1999N388LBSdgair LLC · Port Orange, FLBuilt 1964 · S/N 30-511N38AGBaxter Kyle W · Tumwater, WABuilt 1959 · S/N 24-1259N390WWalter Paul F · Milwaukee, WIBuilt 1970 · S/N 39-39N393TBTom Brown Consulting LLC · Ave Maria, FLBuilt 1969 · S/N 30-1874N397PCPapadopoulos Gustave · Summerland Key, FLBuilt 1962 · S/N 24-3189N39CRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 39-4N3HMTalley John T · Clifton, TXBuilt 1965 · S/N 24-4277N3HRDow Glendal R Trustee · Bedford, TXBuilt 1962 · S/N 24-3126N3MSCarter Zac · Atlanta, GABuilt 1960 · S/N 24-1747N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380N3SGN3sg Enterprises Inc · Wilmington, DEBuilt 1960 · S/N 24-2036N3XEServ Aero Engineering Inc · Salinas, CABuilt 1963 · S/N 30-92N400LBAutumn Crocus LLC · Cincinnati, OHS/N 30-1059N400TDHardy Mikel · Twin Falls, IDBuilt 1968 · S/N 30-1708N40193Rearden Logic Inc · Denver, COBuilt 1959 · S/N 24-1239N40439Usoarflorida LLC · Fort Myers, FLBuilt 1971 · S/N 39-94N405TSRichard N Appling · Ellensburg, WABuilt 1963 · S/N 30-159N407AFRuff Brent M · Santa Clarita, CABuilt 1966 · S/N 30-1285N409LAAnderson Wilma (Lori) · Blue Mound, ILS/N 24-1494N40DACirrus Design Corp · Duluth, MNBuilt 1965 · S/N 30-904N40JSAir Flight Enterprises Inc · South Daytona, FLS/N 24-3269N40RSSaul Gregory D Jr · Glenrock, WYBuilt 1960 · S/N 24-2031N40VKSimply Living LLC · Fort Myers, FLBuilt 1966 · S/N 24-4473N40VMQualitair LLC Trustee · MichelstadtS/N 30-113N40WFGrennell Brian M · Euless, TXS/N 30-971N415HPRichmond George H Jr · Elkhorn, NEBuilt 1963 · S/N 30-181N417BHHugel Bohdan · Selma, NCBuilt 1962 · S/N 24-3108N41AEBowen Haldor S · Sandpoint, IDS/N 24-637N41BPSturdevant Harold L Jr · Kalispell, MTS/N 30-644N41LPulliam Oscar E Jr · Moscow, TNBuilt 1958 · S/N 24-351N41PLTj Air Holdings Inc Trustee · Wilmington, DES/N 30-1293N4236PRegistration Pending · Chandler, AZRegistration pendingS/N 24-1260N4250Leafgreen Jeff A Trustee · Lander, WYBuilt 1959 · S/N 24-894N4269WZeek Michael · Munfordville, KYS/N 30-1258N4284Clements Eric C · Sheridan, WYBuilt 1965 · S/N 24-4284N4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-114N42PMJofredo Corp · Zephyrhills, FLBuilt 1969 · S/N 30-1932N42TPBalkin John S · Bigfork, MTBuilt 1964 · S/N 30-255N430MMMersereau Iden H · Goodyear, AZBuilt 1966 · S/N 24-4525N431ABAirtrust LLC - 18 - Series 18 Trustee · Sheridan, WYS/N 24-4156N434BBElgin Engineering LLC · Arlington, TXBuilt 1966 · S/N 24-4536N43BLockard Seth J · Lebanon, TNBuilt 1963 · S/N 30-226N43TLT M L Aircraft Inc · Narrowsburg, NYBuilt 1971 · S/N 24-5001N444CPMercure Ryan K · Eads, TNBuilt 1963 · S/N 30-230N4483CRich Aden Gene · Sequim, WABuilt 1959 · S/N 24-1257N44PCGenocchio Anthony F · New Port Richey, FLBuilt 1965 · S/N 24-4124
Back to AD 82-23-01 R1