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.

N8298YEstes Bernard R · Bumpass, VABuilt 1967 · S/N 30-1437N8299PFischer Dale R · Laporte, INBuilt 1963 · S/N 24-3277N82RJLynch James D Jr · Ocala, FLBuilt 1966 · S/N 30-1049N8302YArnold Roger R · Jonesville, LAS/N 30-1441N8304YLusk Thomas L · Centennial, COS/N 30-1443N8309YHolman Michael J · Anchorage, AKBuilt 1967 · S/N 30-1448N8310PPremiere Aviation Inc · Concord, CABuilt 1963 · S/N 24-3560N8311PDuckett Kristofer · Fairfield, CAS/N 24-3561N8311YAj Air LLC · Cape Girardeau, MOBuilt 1967 · S/N 30-1450N8313PSpencer Cory · Mobile, ALBuilt 1963 · S/N 24-3563N8313YUnusual Attitudes LLC · Bates City, MOBuilt 1967 · S/N 30-1452N8315PSquawk Wv LLC · Morgantown, WVBuilt 1963 · S/N 24-3565N8315YGolden Compass Aviation LLC · Wilmington, DEBuilt 1967 · S/N 30-1455N8316PHolbrook James K · West Liberty, KYBuilt 1963 · S/N 24-3567N8316YSchubnell Ryan A · Avondale Estates, GAS/N 30-1456N8318PPlane Old Memes LLC · Seminole, FLBuilt 1964 · S/N 24-3569N831JRRegistration Pending · High Springs, FLRegistration pendingBuilt 1959 · S/N 24-585N8320PCallicrate Michael P · Saint Francis, KSBuilt 1963 · S/N 24-3571N8320YKling Aviation Inc · Friendswood, TXBuilt 1967 · S/N 30-1460N8322YDayhoff Miller Alice J · Springfield, OHBuilt 1967 · S/N 30-1463N8324PCirrus Air LLC · Eden, NCBuilt 1963 · S/N 24-3575N8324YStein Anthony J · Locust Grove, GABuilt 1967 · S/N 30-1465N8326YEastern Stearman Inc Trustee · Leesburg, VABuilt 1967 · S/N 30-1468N8327YKaeser Robert E · Lafayette, INBuilt 1967 · S/N 30-1469N8328PSale Reported · Lewes, DESale reportedS/N 24-3581N8328YSims Chris · Colleyville, TXBuilt 1967 · S/N 30-1470N8329YHarbock Inc · Wilmington, DEBuilt 1967 · S/N 30-1471N8331PBurbanks Travis R · Tarzana, CABuilt 1963 · S/N 24-3584N8331YFeit Paul · Osprey, FLS/N 30-1476N8332PGray James Gary · Simpsonville, SCBuilt 1963 · S/N 24-3585N8333PAllred Klein Enterprise LLC · San Diego, CABuilt 1963 · S/N 24-3586N8336PWyatt Gary D · Sun City West, AZS/N 24-3590N8336YPatterson Thomas A · Minerva, OHBuilt 1967 · S/N 30-1481N8337YBorden William · Commerce Township, MIBuilt 1967 · S/N 30-1483N8338PHerndon Properties LLC · Walterboro, SCS/N 24-3593N8339YBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 30-1485N833DFAirdorrin Inc · New Castle, DEBuilt 1967 · S/N 30-1473N8340PChristiansen Lance W · Anacortes, WAS/N 24-3595N8341PLife Is Flying Inc · Deerfield Beach, FLBuilt 1963 · S/N 24-3596N8341YPepper Dale D · Newnan, GABuilt 1967 · S/N 30-1487N8342PGibbs Randy Shane · Louisburg, NCBuilt 1964 · S/N 24-3597N8343YSpector Steven D · Glenview, ILBuilt 1967 · S/N 30-1489N8344PGulledge Richard · Deland, FLS/N 24-3600N8345PMcgough Christopher M Trustee · Hurricane, UTBuilt 1964 · S/N 24-3601N8346PPhelps Michael J Trustee · Oneida, TNBuilt 1964 · S/N 24-3603N8348PEchols Mark R · Diana, TXBuilt 1964 · S/N 24-3605N8348YNelson Brian · Wakefield, NEBuilt 1967 · S/N 30-1495N8349PPickett Douglas M · Romeo, MIBuilt 1964 · S/N 24-3606N8351PComanche Air Holdings LLC · Austin, TXBuilt 1964 · S/N 24-3608N8352YSkylandsair LLC · Port Orange, FLBuilt 1967 · S/N 30-1499
Back to AD 82-23-01 R1