OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N5182LGarden City Aviation LLC · Augusta, GABuilt 1967 · S/N 28-4469N5182SFoster Tyler R · Levelland, TXS/N 28-7105036N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400N5183SWestland Aviation LLC · Lake Havasu City, AZBuilt 1970 · S/N 28-7105037N5183XStory James W · Byhalia, MSBuilt 1969 · S/N 170N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721N5184LOtt Timothy M · Ida, MIBuilt 1967 · S/N 28-4472N5184S1st Cooling Inc · Rockwall, TXBuilt 1970 · S/N 28-7105038N5184XComstock Derrick B · Salol, MNBuilt 1969 · S/N 173N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441N5185QRegistered aircraftBuilt 1989 · S/N 300N51863Green Wendell L · Argyle, TXBuilt 1980 · S/N 46N51865Savage Michael B · Lincoln, CABuilt 1981 · S/N 17274362N5186HPope Brian B · Coalgate, OKBuilt 1975 · S/N 17265365N5186WQuick Janice L · Wrightwood, CABuilt 1961 · S/N 28-221N5186XRochelle Stephen L · Raymond, MSBuilt 1969 · S/N 198N51871Az2026 LLC · Miami, FLBuilt 1980 · S/N 17274366N51875Wings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 17274369N5187ENowak Michael J · Waxahachie, TXBuilt 1978 · S/N 17271760N5187GThompson Edward A · Sunset Beach, NCBuilt 1979 · S/N 17273555N5187JDagger Falls LLC · Boise, IDBuilt 1979 · S/N 313-79N5187LMcclelland Kip · Douglas, GAS/N 28-4475N5187RTke Ltd · Thief River Falls, MNBuilt 1974 · S/N 17263404N5187WGardner Robert E · Dixon, CABuilt 1961 · S/N 28-222N51883Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274371N51885Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274372N5188HHartley Jerome K · Talkeetna, AKBuilt 1949 · S/N 14-506N5188SMiller Kaci · Bullhead City, AZBuilt 1970 · S/N 28-7105046N51890Hyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 17274375N5189LMicic Miodrag · Lake Elsinore, CABuilt 1968 · S/N 28-5129N5189SBender Douglas E · Kendallville, INBuilt 1970 · S/N 28-7105049N518ACGernand Charles · Hoopeston, ILBuilt 2000 · S/N 448-2000N518APWilliams Brian K · Mattituck, NYS/N M-1869N518BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842258N518BW8bravo Wiskey LLC · New Liberty, KYBuilt 1974 · S/N 28-7405240N518CACompass Aviation Inc · Shelby, NCBuilt 1979 · S/N 17273049N518ERoland Kenneth R · Tell City, INS/N R-G-H-1N518PLMoore David P Trustee · Chattanooga, TNBuilt 1975 · S/N AA5B-0144N518RMWinkelmann Pete J · North Fond Du Lac, WIBuilt 2002 · S/N 60099N518SWGilchrist Robert T · White Salmon, WABuilt 1955 · S/N 18-4389N518TPos LLC · Glencoe, MOS/N 3466N518TCBedell Gary L · Henderson, NVBuilt 2001 · S/N 9932CCN518TRCorrina Cumulus LLC · Kalispell, MTBuilt 2001 · S/N 22518N5190LKing Samantha M · Mcdonough, GABuilt 1967 · S/N 28-4479N5190SRobinson Richard D · Montclair, CABuilt 1970 · S/N 28-7105050N5190TMhe Aviation LLC · Las Vegas, NVBuilt 1967 · S/N 141N5191Murray Stewart · Capay, CABuilt 1968 · S/N 432
Back to AD 80-04-03 R2