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.

N67624Hardman Lorin D · Wasilla, AKBuilt 1945 · S/N 13937N67638Blue Feathers Corp · Newark, DEBuilt 1978 · S/N 15281954N67648Flying Vikings Inc · Hayward, CABuilt 1978 · S/N 15281960N67651Salomonsson Mats · Fremont, CABuilt 1978 · S/N 15281963N67652Final Design Group LLC · Hurricane, UTBuilt 1978 · S/N 15281964N67657Jade Air LLC · San Pedro, CABuilt 1978 · S/N 15281965N67701R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281969N67705Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15281971N67708Pischel Tom K · Meadow Vista, CABuilt 1978 · S/N 15281974N67710Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281975N67711Cox Linda M · Christiana, TNFirst renewal noticeBuilt 1978 · S/N 15281976N67728Edj Aviation Ltd · Fort Myers Beach, FLBuilt 1978 · S/N 15281983N67733Righter Douglas D · Bellingham, WABuilt 1978 · S/N 15281986N67746Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15281992N67753Southwinds Export Inc · Kissimmee, FLS/N 15281998N67760Farquar Leasing Inc · North Bend, ORBuilt 1978 · S/N 15282002N67765Guilbeau Austin K · Miami, FLS/N 15282005N67778Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282013N67787Williams Aviation LLC · Maumelle, ARBuilt 1978 · S/N 15282018N6778TAlexander Todd A · Milton Freewater, ORBuilt 1946 · S/N 12-1104N67792City Of Newport News · Newport News, VABuilt 1981 · S/N 15285309N67796Dsr Cherokee 180 LLC · Dallas, TXBuilt 1978 · S/N 15282025N67797Indiana State University · Terre Haute, INBuilt 1978 · S/N 15282026N677NADunbar Dallas Alton III · Bluffton, SCBuilt 2004 · S/N 20-1029N67807Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15282031N67810Hernandez Jason Joseph · Allen, TXBuilt 1978 · S/N 15282033N67818Tlb Inc · Howell, NJBuilt 1978 · S/N 15282036N67825Kentucky Airmotive Inc · Mt Sterling, KYBuilt 1978 · S/N 15282040N67840Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282049N67842Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1978 · S/N 15282051N67844Patel Pragnesh · Cerritos, CABuilt 1978 · S/N 15282053N67847Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15282056N67852Sunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15285312N67856Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282061N67859Guerra Gerald T · Sandusky, OHBuilt 1978 · S/N 15282063N67864Amoth Travis M · Princeton, CABuilt 1978 · S/N 15282068N67865Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1978 · S/N 15282069N67888Flight Directors LLC · Fifield, WIBuilt 1978 · S/N 15282077N678BBDalton Raymond O Trustee · Nashville, TNBuilt 1972 · S/N AA1A-0378N678KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15281673N67904Mirza Wajahat · College Station, TXBuilt 1978 · S/N 15282089N67920Thompson William G · Mattawa, WABuilt 1978 · S/N 15282099N67923Kaluahine Fredstan K · Lihue, HIS/N 15282101N67924N67924 LLC · Somers, CTBuilt 1978 · S/N 15282102N67930Colonial Air Inc · New Bedford, MABuilt 1978 · S/N 15282106N67958Stone Wall Acres · Antigo, WIBuilt 1978 · S/N 15282115N67967Moore Charles E · Gibsonville, NCBuilt 1978 · S/N 15282120N67973Wings Over Texas Holding LLC · Denton, TXBuilt 1978 · S/N 15282121N67991Rainier Flight Service LLC · Renton, WABuilt 1978 · S/N 15282124N67993Johnson Joshua S · Lake Jackson, TXBuilt 1978 · S/N 15282126
Back to AD 80-25-02 R2