OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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.

N86682Twardokens Eva M · Aptos, CABuilt 1974 · S/N 143-74N86711Crane David D · Cadott, WIBuilt 1974 · S/N 654-74N86713Tuckerman Flying Service Inc · Tuckerman, ARBuilt 1974 · S/N 681-74N86714Odonnell Daniel V · Dover, DEBuilt 1974 · S/N 10-74N86715Yellerhammer LLC · Warner Robins, GABuilt 1974 · S/N 1017-74N86727Murray Eric J · Kamas, UTBuilt 1974 · S/N 656-74N8672VHarris Kenneth L · Greeley, COBuilt 1975 · S/N 174-75N86738Myran Kenneth · Taylor, NDBuilt 1974 · S/N 657-74N86742Parker James T · Palmer, AKBuilt 1974 · S/N 431-74N8674VIberlin Ranch · Gillette, WYBuilt 1975 · S/N 826-75N86752J&M Aviation Supply Inc · Shreveport, LABuilt 1974 · S/N 292-74N8677VAlbij3 LLC · Milton, FLBuilt 1975 · S/N 315-75N86796Perkins Brad · Thomas, OKBuilt 1974 · S/N 659-74N867AAWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264498N86807Wells Jeffrey V · Mackay, IDS/N 22-74N86813Holton Allen M Jr · Torrance, CABuilt 1974 · S/N 1016-74N86820Piercy Ron · Moses Lake, WABuilt 1974 · S/N 433-74N86822Hofer Gary D · Huron, SDBuilt 1974 · S/N 672-74N86828Robinson William D · Greer, SCBuilt 1974 · S/N 1019-74N86834Cardinal Aviation Inc · Murray, KYBuilt 1974 · S/N 435-74N86838White Sean Patrick · Fairbanks, AKS/N 688-74N8683VDaniel Shannon B · El Dorado Springs, MOBuilt 1975 · S/N 1098-75N86846Woolard Farms Leasing Inc · Corning, ARBuilt 1974 · S/N 669-74N86847Kilbourn James A · Happy Valley, ORS/N 432-74N86849Sweet Ranch Inc · Hyannis, NEBuilt 1974 · S/N 63-74N86854Moore Planting Co Inc · Cary, MSBuilt 1974 · S/N 6-74N86863Pruitt Leland L · Jones, LABuilt 1974 · S/N 36-74N86872Chupito Sabrocito LLC · Paso Robles, CABuilt 1974 · S/N 1028-74N86879Knik Flying Club LLC · Anchorage, AKBuilt 1975 · S/N 856-75N8687VCollum Aviation LLC · Milton, FLBuilt 1975 · S/N 184-75N86883High Exposure Inc · Wilmington, DEBuilt 1974 · S/N 680-74N86885Mason Peter Trustee · Santa Paula, CABuilt 1974 · S/N 37-74N8688VHawkeye Aviation LLC · Newport, ARBuilt 1975 · S/N 1096-75N86890E-Commerce Education Foundation · Tulsa, OKBuilt 1974 · S/N 443-74N86892Goodman Jack · Memphis, TNBuilt 1974 · S/N 296-74N8689VZacheis Henry M · Fairbanks, AKBuilt 1975 · S/N 841-75N868FACardoza Todd J · Castro Valley, CAS/N 24-0980N868SAS O W Aviation LLC · Crystal River, FLS/N 17266439N86901Rudderow Preston Trustee · Anchorage, AKBuilt 1974 · S/N 23-74N86911Schneberger Bart A · Nome, AKBuilt 1974 · S/N 25-74N8691VAviation Specialists LLC · Wilmington, DES/N 1097-75N86928Collum Aviation LLC · Milton, FLBuilt 1974 · S/N 32-74N8692VLohr Martin J · Petersburg, AKBuilt 1975 · S/N 831-75N86936Lewis Aviation Inc · Wilmington, DEBuilt 1974 · S/N 444-74N8693VMichael A Levenhagen · North Fort Myers, FLBuilt 1975 · S/N 185-75N86948Guglietta Jon R · Harwinton, CTBuilt 1974 · S/N 147-74N86950Dale Jane L · Willow, AKS/N 39-74N86953Madden Russell · Graford, TXBuilt 1974 · S/N 152-74N86954Breaking Wind LLC · Alabaster, ALBuilt 1974 · S/N 148-74N86957Swan Creek Flying Club · Ayr, NDBuilt 1974 · S/N 692-74
Back to AD 80-25-07 R1