OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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-02-R2')
    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-02-R2')
  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.

N489BBBoatman John H Jr · Smyrna, TNS/N JB001N48GKAnderson Kirby L · Mcveytown, PABuilt 1980 · S/N 48N48MRCasey Mike P · Whitefish, MTBuilt 1947 · S/N 12-2583N48SUGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285186N49004Oakland Flyers LLC · Oakland, CAS/N 15281094N49005Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281095N4900HNew Horizon Aviation Inc · Warwick, RIBuilt 1980 · S/N 15284009N4900LJonghan Park · Stanton, CABuilt 1980 · S/N 15284241N4900ZPeden Max S · Eagleville, TNBuilt 1961 · S/N 22-8483N4901MSchaller Lee · New Athens, ILBuilt 1947 · S/N 11-422N4901ZUnger Michael D · Bellingham, WAS/N 22-8486N49024B2fh Ltd · Allentown, NJBuilt 1977 · S/N 15281106N49025Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281107N49039Welcome Aviation LLC · Hayward, CABuilt 1977 · S/N 15281115N49043Edwards Pacific Aviation Corp · Dover, DEBuilt 1977 · S/N 15281117N49055Lima Aviation LLC · Lake Havasu City, AZBuilt 1977 · S/N 15281126N49060Skylogix Aircraft LLC · La Habra, CABuilt 1979 · S/N 15283410N49070Ilmberger Stephen Joseph · San Leandro, CABuilt 1977 · S/N 15281133N49075Mccullough Nancy D · Abilene, TXBuilt 1979 · S/N 15283412N49079Alexander Joseph · Hamilton, INBuilt 1977 · S/N 15281138N49090Victory Aviation LLC · Winchester, VABuilt 1979 · S/N 15283415N49094Fleck Richard N Trustee · Camarillo, CABuilt 1979 · S/N 15283416N4909ZVersatile Aviation LLC · Waterford, MIBuilt 1961 · S/N 22-8494N4910BCooper Ronald C · Fowlerville, MIBuilt 1979 · S/N 15283702N4911ZSamson Robert L · Phoenix, AZBuilt 1961 · S/N 22-8496N49120Aviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283425N49123Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 15281152N49125Morey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283426N49126Flight Expo Inc · Princeton, MNS/N 15283427N49138Osborn Scott R · Rch Palos Vrd, CABuilt 1979 · S/N 15283430N49142Zion Summit Holdings LLC · Wesley Chapel, FLBuilt 1977 · S/N 15281161N49144Westfall Benjamin C · Coeur D Alene, IDBuilt 1977 · S/N 15281163N49150Skytrain Aviation LLC · Sumner, ILS/N 15281167N49151Zhang Victoria · Daytona Beach, FLBuilt 1979 · S/N 15283432N49159Comer Jacob W · Troy, MOBuilt 1977 · S/N 15281172N4915PAubry Nicolas L · Port Jefferson, NYBuilt 1981 · S/N 15284840N4915ZPamment Melvin M · Arlington, KYBuilt 1961 · S/N 22-8501N49161Rohan Gerard K Sr · Marion, WIBuilt 1978 · S/N 15281174N4917ZGibsons Gas Inc · Holland, NYS/N 22-8506N49189Anderson Seth A · Buckeye, AZS/N 15281182N4918HMarks Aviation Corp · Beverly Hills, CABuilt 1979 · S/N 15284020N49191Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281184N49194Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281186N49197Wilt Aviation Consulting LLC · Sebastian, FLBuilt 1977 · S/N 15281188N49199Wygant Amanda N · Copper Center, AKBuilt 1977 · S/N 15281189N4919PRiggs Charles A · Pembroke Pines, FLBuilt 1981 · S/N 15284841N49202Skylogix Aircraft LLC · La Verne, CABuilt 1977 · S/N 15281191N49215Dukelow Thomas W · Bad Axe, MIBuilt 1979 · S/N 15283437N49226Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1979 · S/N 15283439N4922BAvcorp Holdings Inc · Jackson, MIBuilt 1979 · S/N 15283706
Back to AD 80-25-02 R2