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.

N7460PStevenson George Otis · Wheatland, WYBuilt 1961 · S/N 24-2650N7463YSkyway Flight Service LLC · Jonesboro, ARBuilt 1964 · S/N 30-526N7466PJmj Aviation LLC · Kalispell, MTS/N 24-2657N7468PMarlott Corwin · Spokane, WAS/N 24-2659N7468YThys Edouard B · Olympic Valley, CABuilt 1964 · S/N 30-531N7469YStader Stacy H · Altoona, FLBuilt 1964 · S/N 30-532N7470PCarey Transport · Baker City, ORBuilt 1961 · S/N 24-2661N7471YLi Yilin · Alma, MIBuilt 1964 · S/N 30-536N7473YSale Reported · Palmer, AKSale reportedBuilt 1964 · S/N 30-538N7475YOverseas Aviaton Inc · Wilmington, DEBuilt 1964 · S/N 30-540N7476YWilliam L Stewart Code Supplies Inc · Rossville, TNBuilt 1964 · S/N 30-541N7478PHanderson Ronald J Sr · Sitka, AKS/N 24-2671N7479PThomas Mark · Princeton, KYBuilt 1961 · S/N 24-2672N747KPDeer Howard W III · Reston, VABuilt 1966 · S/N 30-1223N7480PDavenport Jimmy J · Hayesville, NCS/N 24-2673N7482PN9246k Corp LLC · Federal Way, WABuilt 1961 · S/N 24-2675N7485PE R V Air LLC · Jacksonville, FLBuilt 1961 · S/N 24-2678N7485YCline Aircraft LLC · Mena, ARBuilt 1964 · S/N 30-546N7486PMakee Markus J · Painesville, OHBuilt 1961 · S/N 24-2679N7486YGardner Canaan · Chandler, OKBuilt 1964 · S/N 30-547N7487PShockley Lee W · Denver, COBuilt 1961 · S/N 24-2680N7488P2final LLC · Leesburg, VABuilt 1961 · S/N 24-2681N7489PRegistration Pending · Whitefish, MTRegistration pendingBuilt 1961 · S/N 24-2682N7490PRobinson John W · Ten Mile, TNBuilt 1961 · S/N 24-2683N7492PCache Rentals 401k P.S.P. · Greeley, COS/N 24-2686N7493PBassar Michael · Eagle, MIBuilt 1961 · S/N 24-2687N7494PM And P Aviation Inc · Albia, IABuilt 1961 · S/N 24-2689N7494YRay James O III · Mc Rae, GABuilt 1964 · S/N 30-555N7495PSale Reported · Fort Lauderdale, FLSale reported, pending cancellationBuilt 1961 · S/N 24-2690N7496PS & S Air Inc · Wilmington, DEBuilt 1961 · S/N 24-2691N7497PLift Aircraft LLC · Carmel, INBuilt 1961 · S/N 24-2692N7498PKarnegis Frank J · Senoia, GABuilt 1961 · S/N 24-2693N7499PTri-C Farms · Tompkinsville, KYBuilt 1961 · S/N 24-2696N74BNBig Bend Community College Foundation · Moses La, WABuilt 1969 · S/N 30-1806N74YCButzer Brian K · Boca Raton, FLBuilt 1969 · S/N 30-1847N7500PBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 24-2699N7503PHouseth Timothy C · Hastings, MNBuilt 1961 · S/N 24-2704N7503YCunneen Sean M · Vista, CABuilt 1964 · S/N 30-565N7509PSuperbird Aviation LLC · Atlantic, IABuilt 1961 · S/N 24-2710N750HKRegistration Pending · Lutz, FLRegistration pendingS/N 30-947N7510PMavco Corp · Lewes, DEBuilt 1961 · S/N 24-2711N7515PRyan John David · Fort Rucker, ALBuilt 1961 · S/N 24-2716N7515YJohnson Max L Jr · Greenville, SCBuilt 1964 · S/N 30-579N7516PHawkinson Dustin R · Glendale, AZBuilt 1961 · S/N 24-2717N7517PRitzheimer Eric R · Glendale, AZS/N 24-2718N7518PLasswell Joel E · Arcola, ILS/N 24-2719N7519YDunshee Kevin G · La Luz, NMBuilt 1964 · S/N 30-584N751WWVicentin De Oliveira Ricardo · Winter Garden, FLBuilt 1967 · S/N 30-1449N7520PRomo Victor Gerardo · Menifee, CAS/N 24-2722N7520YWendelburg Kevin R · Moreland, GABuilt 1964 · S/N 30-585
Back to AD 82-23-01 R1