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.

N8527YHatbright Farm LLC · Wilmington, DEBuilt 1968 · S/N 30-1688N8528YYoung David A · Lakeland, FLBuilt 1968 · S/N 30-1689N8530YMouat Michael W · Hemet, CABuilt 1968 · S/N 30-1691N8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1696N8538YRothstein Steven R · Punta Gorda, FLBuilt 1967 · S/N 30-1606N8539YTwinco Leasing LLC · Yacolt, WABuilt 1967 · S/N 30-1626N8540YCli Aerospace LLC · Appleton, WIS/N 30-1568N8542YAviation Training Solutions LLC · Hilo, HIBuilt 1967 · S/N 30-1598N8544PSetzler Frank · Gilbert, AZBuilt 1964 · S/N 24-4001N8547PStewart James David · Mesa, AZBuilt 1964 · S/N 24-4004N8549PWest Texas Weather Modification Association · San Angelo, TXBuilt 1964 · S/N 24-4006N8550PNick Smith And Associates Inc · Mcallen, TXBuilt 1964 · S/N 24-4007N8551PBratcher Troy L · Williston, NDS/N 24-4008N8555YScharf Mark T · Rosamond, CAFirst renewal noticeBuilt 1968 · S/N 30-1702N8556PLandis Ehrin · Redding, CABuilt 1964 · S/N 24-4013N8557PQuaal Ranch Inc · Sundance, WYS/N 24-4014N8558PBaughman Kevin R · Avinger, TXBuilt 1964 · S/N 24-4015N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705N8559PMcclean Adam D · Lakeport, CABuilt 1964 · S/N 24-4016N8560YSullian John J · Alexandria, VAS/N 30-1707N8562PRegistration Pending · Waukee, IARegistration pendingBuilt 1965 · S/N 24-4019N8564YGingers Holdings Inc · Jacksonville, FLBuilt 1968 · S/N 30-1711N8565PLynn Owen P · Vinemont, ALS/N 24-4021N8566PRicciardi Brian · Dennis, MABuilt 1964 · S/N 24-4022N8566YClarke George W III · Sierra Vista, AZBuilt 1968 · S/N 30-1714N8567PJeewek Rita M Trustee · Parma, OHBuilt 1964 · S/N 24-4023N8567YJohnson Randy D · Becket, MAS/N 30-1715N8569PPurpose Flight Inc · Wilmington, DES/N 24-4026N8571PBrackett William E · Capitan, NMBuilt 1964 · S/N 24-4028N8572PService Drug DBA · Chadron, NEBuilt 1964 · S/N 24-4029N8573PMounicou Sonny M · Olive Branch, MSBuilt 1964 · S/N 24-4030N8577PPrice Isaac H · Flat Rock, ALBuilt 1964 · S/N 24-4034N8578PGibbs Gregory Curtis · Engelhard, NCBuilt 1964 · S/N 24-4035N8579PWor LLC · Jamaica Beach, TXBuilt 1964 · S/N 24-4036N8582PSchwalbach Russell R · Bondurant, IABuilt 1964 · S/N 24-4039N8583PLl Aviation LLC · Kansas City, MOBuilt 1964 · S/N 24-4040N8583YGray Michael W · Cheyenne, WYBuilt 1968 · S/N 30-1736N8584PHackens Donald G · New Underwood, SDBuilt 1964 · S/N 24-4041N8585PNelson Christopher A · Silver Spring, MDBuilt 1964 · S/N 24-4042N8585YGospel Ministeries International Inc · Mc Donald, TNBuilt 1968 · S/N 30-1738N8586YTrue Glenn C Jr · Phoenix, AZBuilt 1968 · S/N 30-1739N8590YNorthern Aviation LLC · Palmer, AKBuilt 1968 · S/N 30-1641N8593YNickajack North LLC · Ocala, FLS/N 30-1640N8595YKor Reese W · Piedmont, SDBuilt 1967 · S/N 30-1624N8596YLeap Aviation Inc · Wilmington, DES/N 30-1623N8597PIsbell James R · Denison, TXBuilt 1964 · S/N 24-4056N8597YTaylor Douglas S · Fairfield, CABuilt 1967 · S/N 30-1653N8598YGulf Coast Aviation LLC · New Orleans, LABuilt 1967 · S/N 30-1607N85VLBowers Jay · Farwell, TXBuilt 1967 · S/N 30-1509N8600YMontcalm Kevin L · Mansfield, LABuilt 1968 · S/N 30-1740
Back to AD 82-23-01 R1