OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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-04-03-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-04-03-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.

N9058DBallard David L Trustee · Chugiak, AKBuilt 1958 · S/N 22-6198N9058JRubinic Brandon S · Harrisburg, PABuilt 1966 · S/N 28-3092N9058LLucius William C · Moosic, PABuilt 1970 · S/N 220-70N9059DGladstone Stephen · Mesa, AZS/N 20570N9059QStevens Donald F · Canton, GAFirst renewal noticeBuilt 1981 · S/N 0143N905AZN905az LLC · Miami, FLBuilt 1986 · S/N 17276651N905DWDue South LLC · Wilmington, DEBuilt 2006 · S/N 22780N905KSZoppe Eduardo · Lakewood Ranch, FLBuilt 1985 · S/N 17276516N905WAMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17269967N9060HJ&S Flying Enterprises LLC · Zanesville, OHBuilt 1975 · S/N 17265922N9060JGillis Joseph V · Tempe, AZBuilt 1966 · S/N 28-3094N9060LShank Paul L · Gaithersburg, MDBuilt 1970 · S/N 275-70N9061DRender Thomas R · Eden Prairie, MNFirst renewal noticeBuilt 1956 · S/N 18-6426N9062JVernon Sharnell Tamieko · Phoenix, AZS/N 28-3096N9062KMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7816187N9062LR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 221-70N9063DHanson Lavon T · Saint Ignatius, MTBuilt 1958 · S/N 18-6428N9063JHardison Samuel H · Mountain View, ARS/N 28-3097N9064JSolomon Michael Lee · Hope Mills, NCBuilt 1966 · S/N 28-3099N90669Cape Copters LLC · Scott City, MOBuilt 1981 · S/N 0119N9067DWing Robert E · Fairbanks, AKS/N 18-6432N9067JEvans Jennifer M · Escalante, UTS/N 28-3102N90687Robinson Jere L · Burnet, TXBuilt 1968 · S/N 18-8734N9068HGundlach Mark A · Fruitland, WABuilt 1975 · S/N 17265928N9068JGregory Brent · Townsend, DES/N 28-3103N9068SBuehler Andrew · Eatonville, WABuilt 1981 · S/N 0172N9069FWoodman Dwight C · Hudson, FLBuilt 1981 · S/N 0177N906CCColumbus Paul S · Laguna Beach, CABuilt 2001 · S/N 9924CCN906GSStevens Donald R · North Plains, ORBuilt 1989 · S/N 20241N906JBAcosta Marcos E · Yorktown Heights, NYBuilt 1976 · S/N AA5A-0196N906KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272697N906MDFive Rivers Flight Training LLC · Livermore, CABuilt 1976 · S/N 17268038N906PSGravitas Services LLC · Richmond Hill, GAS/N 28-777N906WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17268112N906WFPapesh Sandra J · Cottonwood, CABuilt 1971 · S/N 28-7125163N90704Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA-5A0301N9070JCruiser Club Inc · Wahpeton, NDS/N 28-5115N9070WUwharrie Flying Club Inc · Albemarle, NCBuilt 1965 · S/N 28-10670N9071DSturgis Richard G · Wasilla, AKS/N 18-6437N9071LWolfley Jody K · Mountain Home, IDS/N 276-70N9073JStewart Kenneth E Trustee · Raleigh, NCBuilt 1966 · S/N 28-3109N90743Byrne Matthew A · West Allis, WIBuilt 1981 · S/N 0246N90744Central Virginia Aviation Inc · North Dinwiddie, VAS/N 0250N9074DHill Russell DBA · Seminole, TXBuilt 1981 · S/N 0234N9074JEast Kentucky Aviation LLC · Ashland, KYBuilt 1966 · S/N 28-3110N90759Kemp Acquisitions LLC · Lone Jack, MOBuilt 1982 · S/N 0254N9075VRankin David W · Bend, ORBuilt 1968 · S/N 690002N9075ZLimbacher Richard A · Stone Creek, OHBuilt 1982 · S/N 0253N9076HBeachy Jonas D · Whittington, ILBuilt 1989 · S/N 11040CN9076JMidvale Flying Club Inc · Midvale, IDBuilt 1966 · S/N 28-3112
Back to AD 80-04-03 R2