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.

N6141PRs Agricultural Operations LLC · Dell City, TXS/N 24-1242N614JDCc Aviation Inc · Tracy, CABuilt 1967 · S/N 30-1517N614RSecker David · San Jose, CABuilt 1964 · S/N 30-658N6150PCobb Berrien · Smyrna, GABuilt 1959 · S/N 24-1251N6151PRoberson Michael B · Winterville, NCBuilt 1959 · S/N 24-1252N6154PLonhart Donald E · Greeley, COBuilt 1959 · S/N 24-1255N6155PSturm Steve G Trustee · Springdale, ARBuilt 1959 · S/N 24-1256N6157PFrazier Jon A · Vista, CABuilt 1959 · S/N 24-1258N6160PBbg Air Ventures LLC · Chandler, AZBuilt 1959 · S/N 24-1261N6162PKiester Michael E · Duncan, OKBuilt 1959 · S/N 24-1263N6163PCommache Avn Inc · Flint, MIBuilt 1960 · S/N 24-1264N6167PRico Nathaniel J · Astoria, ORBuilt 1959 · S/N 24-1268N6169PKlier John M · Alpine, CABuilt 1959 · S/N 24-1270N616SRBarendregt Melvin E · Heyburn, IDS/N 24-1800N6170PMaurer Bruce C · Power, MTBuilt 1959 · S/N 24-1271N6173PSwenson James A · Lake Point, UTBuilt 1959 · S/N 24-1274N6174PAbernathy Larry D · Vernon, TXBuilt 1959 · S/N 24-1275N6178PFolse Eldred J · North Las Vegas, NVBuilt 1959 · S/N 24-1280N617EDMente Charles · Homestead, FLBuilt 1968 · S/N 24-4765N6181PLowe David M · Sacramento, KYBuilt 1959 · S/N 24-1283N6184PCollins Michael J · Chandler, AZBuilt 1959 · S/N 24-1286N6187PFlowers Ricky B · Klamath Falls, ORBuilt 1959 · S/N 24-1289N6192PLevin Sidney M · Buffalo Grove, ILBuilt 1959 · S/N 24-1294N6194PCrosby Tire & Body Shop Inc · Crosby, NDBuilt 1959 · S/N 24-1296N61BBAeronautical Technical Service Inc · Collierville, TNS/N 30-875N61UComanche Skye LLC · Savannah, GABuilt 1966 · S/N 30-1004N6202PCollins Owen Stewart · Toccoa, GAS/N 24-1303N6203PClark Jason H · Ridgecrest, CABuilt 1959 · S/N 24-1304N62052Bolinger Ray G · Kuna, IDBuilt 1959 · S/N 24-1235N6205PTwo Dot Aircraft Ll · Kalispell, MTS/N 24-1307N6207PSquawk 2310 LLC · Ridgefield, WABuilt 1959 · S/N 24-1309N6210PHolbrook Glen A · Marion, WIBuilt 1959 · S/N 24-1312N6211PPounds Kenneth M · Pueblo West, COBuilt 1959 · S/N 24-1313N6212PJobin Lyle S · Madeira Beach, FLBuilt 1959 · S/N 24-1314N6216PDuvall James Grafton III · Silver Springs, NVBuilt 1959 · S/N 24-1318N6218PSmith Ron E · Goodlettsville, TNBuilt 1959 · S/N 24-1320N6221PLicata Paul Z · Mexico, MOS/N 24-1323N6222PPacheco Carlos Antonio · Yuma, AZBuilt 1959 · S/N 24-1324N6224PDattilio Joseph · Wasilla, AKS/N 24-1326N6225PMcvey Charles D · Merritt Island, FLBuilt 1959 · S/N 24-1327N6226PHofstetter Fred M · Boerne, TXBuilt 1959 · S/N 24-1328N6229PA2a Aviation Inc · Simsbury, CTBuilt 1959 · S/N 24-1332N622BRidley Aircraft & Aviation Services LLC · Gilbert, AZBuilt 1966 · S/N 1341N6236PHill Scott G · Mcdonough, GABuilt 1959 · S/N 24-1341N6240POrtiz Raul D · Fredericksburg, VABuilt 1959 · S/N 24-1345N6244PSimon Projects LLC · Sebastian, FLBuilt 1959 · S/N 24-1349N6245PBishop Warren · Iowa City, IABuilt 1959 · S/N 24-1351N6249PKeller Richard A · Stacy, MNBuilt 1959 · S/N 24-1356N6251PPearce Donnie D · Mena, ARBuilt 1959 · S/N 24-1358N6254PMcphee Michael Andrew · Cherokee, TXBuilt 1959 · S/N 24-1361
Back to AD 82-23-01 R1