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.

N8952PBreckenridge Lester James Jr Trustee · Appleton City, MOBuilt 1966 · S/N 24-4409N8953PTendie Time Flying LLC · San Diego, CABuilt 1966 · S/N 24-4410N8954PKramer Kartie K · Mckinney, TXBuilt 1966 · S/N 24-4411N8955PPropwash LLC · Princeville, ILBuilt 1966 · S/N 24-4412N8955YCarter Howard A III · Stafford, VABuilt 1971 · S/N 39-115N8956YDark Side Aeronautical Inc · Wilmington, DEBuilt 1971 · S/N 39-116N8957PCreedon John · Mc Cormick, SCBuilt 1966 · S/N 24-4414N8958PVan Dyke David M · Portland, ORBuilt 1966 · S/N 24-4415N8959PMosel Properties LLC · Marrero, LABuilt 1966 · S/N 24-4416N8961PRegistered aircraftBuilt 1966 · S/N 24-4418N8962PDunning John · Stow, MABuilt 1966 · S/N 24-4419N8962YChoate Cass Joseph · Toone, TNS/N 39-122N8963YNess Rent A Car Inc · Fargo, NDS/N 39-123N8964PPerkins Michael W · Warren, MIBuilt 1966 · S/N 24-4421N8965PChancellor Richard · Palmer Lake, COBuilt 1966 · S/N 24-4422N8965YLucid Thought Consulting LLC · Terre Haute, INS/N 39-127N8966PLautensack Peter · Oswego, NYBuilt 1966 · S/N 24-4423N8967YQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-130N8969YTrident Aero Services LLC · Park City, UTBuilt 1971 · S/N 39-132N8970PPodraza Kevin M · Dekalb, ILBuilt 1966 · S/N 24-4427N8971PDerrel Luce Pc · Waco, TXBuilt 1966 · S/N 24-4428N8971YLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 39-134N8972PHardy Douglas · Lakewood, CABuilt 1966 · S/N 24-4429N8973PBrockwell Derrell Randel · Oakland, TNBuilt 1966 · S/N 24-4430N8973YAire Ryder LLC · Roseville, MNS/N 39-139N8974P4papa LLC · Gig Harbor, WABuilt 1966 · S/N 24-4432N8976YAfricano Aircraft Management LLC DBA · Chicago, ILS/N 39-142N8977PWarrior Up LLC · Clayton, NCBuilt 1966 · S/N 24-4435N8979PShortridge Mary E · Bennet, NEBuilt 1966 · S/N 24-4438N8980PLittle Wood LLC · Bellevue, MIBuilt 1966 · S/N 24-4439N8980YTomu Fly LLC · Vero Beach, FLS/N 39-146N8981YGrey Enterprises Holdings LLC · Kalispell, MTBuilt 1972 · S/N 39-138N8982PAviation & Aerospace Consulting & Mgmt Svcs LLC · Bullhead City, AZBuilt 1966 · S/N 24-4441N8982YCovington James P · Poplar Grove, ILBuilt 1972 · S/N 39-147N8983PBlum Kenneth J · Truckee, CABuilt 1966 · S/N 24-4442N8984PMarchant Scott · Clackamas, ORBuilt 1966 · S/N 24-4443N8985PSharp Charles Barry · Fulton, KYBuilt 1966 · S/N 24-4445N8986PNielsen James R · Carson City, NVS/N 24-4446N8986YN8986y LLC · Orlando, FLBuilt 1972 · S/N 39-151N8990PBaitanator Inc · Lamesa, TXBuilt 1966 · S/N 24-4451N8991PCendejas Agustin · Chino, CABuilt 1966 · S/N 24-4452N8992PL And L Aviation Inc · Mount Airy, MDBuilt 1966 · S/N 24-4453N8993PPitcher Benjamin Alan · Fishers, INBuilt 1966 · S/N 24-4454N8997PF2 Management LLC · Canoga Park, CAS/N 24-4458N8998PMoore Jeffrey · Oceanside, CABuilt 1966 · S/N 24-4459N8999PBednorski Craig A Trustee · Grass Valley, CABuilt 1966 · S/N 24-4376N89GBHerrington Kevin · Honey Grove, TXS/N 24-4779N8FTop Flight Aviation Inc · Corona, CAS/N 30-1312N8LBHill Mark Daniel · Magnolia, TXBuilt 1969 · S/N 30-1788N8MZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 301648
Back to AD 82-23-01 R1