OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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.

N57423Pardue Roy S · Clifton, VABuilt 1973 · S/N 92-73N57424Wood Flying Inc · Panhandle, TXBuilt 1973 · S/N 499-73N57428Zygomalas Stefanos · San Francisco, CABuilt 1973 · S/N 370-73N5742ZBootz Terry A · Canyon Lake, TXBuilt 1984 · S/N 24-1451N57430Swanson Michael D · Council Bluffs, IABuilt 1973 · S/N 944-73N57433Propwash LLC · Princeville, ILBuilt 1973 · S/N 88-73N57435Morkassel Gerald N · Waverly, OHBuilt 1973 · S/N 374-73N57440Frankel Daniel A · Madison, OHBuilt 1973 · S/N 946-73N57442Whiting Lawrence M · Silverton, ORBuilt 1973 · S/N 506-73N57446Williams Martin · Wasilla, AKBuilt 1973 · S/N 507-73N57447Hicks Richard Ted · Statesville, NCS/N 263-73N5744JLopresti Curtis · Vero Beach, FLBuilt 1984 · S/N 24-1443N57454Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 90-73N57456Marshall James I · Roosevelt, UTBuilt 1973 · S/N 508-73N57458Flytrek3 LLC · Palmer, AKBuilt 1973 · S/N 509-73N5745QHuseman Joseph F · De Witt, IABuilt 1965 · S/N 3159N57461Hall Willard · Beaumont, TXBuilt 1973 · S/N 949-73N57467Loper Jonathan D · Dallas, TXBuilt 1973 · S/N 377-73N57468Lease Gregory C · Grand Rapids, MNBuilt 1973 · S/N 514-73N57469Miller Christopher A · Chico, CABuilt 1973 · S/N 951-73N5746QKing Jeremy · Sandy Springs, GAS/N 3075N57470Hicks James W · Valparaiso, INBuilt 1973 · S/N 375-73N57472Kutztown Aviation Service Inc · Germansville, PABuilt 1973 · S/N 512-73N57473Duncan Michael E · Auburn, CABuilt 1973 · S/N 378-73N57474Harding William R Jr · Quinlan, TXBuilt 1973 · S/N 950-73N57476Boucher Gregg D · Hinsdale, MTBuilt 1973 · S/N 516-73N57481Bartels Pamela K · Marion, NCBuilt 1973 · S/N 952-73N57487Willis Nelson W · Lebanon, TNS/N 520-73N57488Rocky 80 Inc · Ethridge, MTBuilt 1973 · S/N 521-73N5748EInternational Air Services Inc Trustee · Carson City, NVS/N 17271930N57492Trimble Tanner J · Blue Rapids, KSBuilt 1984 · S/N 24-1455N57498Ck Leasing Services LLC · Wilmington, DES/N 525-73N5749MRegistration Pending · Apple Valley, CARegistration pending, canceledS/N 24-1609N5749XFlash Aviation LLC · Elkton, MDBuilt 1984 · S/N 24-1454N574DEMuggsys Aviation Services LLC · Crittenden, KYBuilt 1974 · S/N 172-62959N57503Martin William A · Nashville, TNBuilt 1973 · S/N 95-73N57505Archipelago Group Llcc · Alexandria, VAS/N 267-73N5750MStites Holdings LLC · Seattle, WAS/N 24-1457N5750QMelnyk Richard V · Uniontown, PABuilt 1965 · S/N 3077N57515Peterson Dean · Gothenburg, NEBuilt 1973 · S/N 380-73N57517Du Aircraft Leasing · Green Bay, WIS/N 526-73N57519L & L Flying Inc · Glen Allan, MSS/N 532-73N5751EFlight Tech Inc · Arlington, WAS/N 17271931N57522Baker Brad L · Salcha, AKBuilt 1973 · S/N 534-73N5752QJackson John E · Oak Harbor, WABuilt 1965 · S/N 3078N57540Trent Blaine · Fort Myers, FLBuilt 1984 · S/N 24-1459N5754ECox Charles C · Hood River, ORBuilt 1978 · S/N 17271934N5754QHamm Martin C · Southport, NCBuilt 1965 · S/N 3079N57552Sheets Gregory W · Ocala, FLBuilt 1984 · S/N 24-1460N57557Hopping Jon · La Mesa, CABuilt 1984 · S/N 24-1461
Back to AD 80-25-07 R1