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.

N9521JGeesaman Brian K · Mount Pleasant, PABuilt 1966 · S/N 28-3739N9521WFlap Happy LLC · Sheridan, WYBuilt 1967 · S/N 28-22948N95225Cherokee 95225 LLC · Provo, UTS/N 28-25851N9522HUrbas Robert M · Rockford, ILBuilt 1975 · S/N 17266198N9522WPrio Frank A · Milwaukee, WIBuilt 1967 · S/N 28-22949N95231Duncan Paul D · Norfolk, NEBuilt 1969 · S/N 28-25856N95236Plane Crazy LLC · Bennington, NEBuilt 1969 · S/N 28-25857N95237Klassen Glenn Kurt · Chandler, AZBuilt 1969 · S/N 28-25858N95238Date Greg · Spokane Valley, WABuilt 1969 · S/N 28-25859N9523DHauser Nathan S · Newark, DEBuilt 1958 · S/N 22-6431N9523HVictor James A · Kingsville, OHBuilt 1975 · S/N 17266199N9523JMichalka James R · Portage, MIBuilt 1966 · S/N 28-3648N9523LCnaa LLC · Mooresville, NCBuilt 1974 · S/N AA5-0523N9523WOberg Harry W C III · Evanston, WYBuilt 1967 · S/N 28-22950N95244Banas Darryl P · Waco, TXBuilt 1969 · S/N 28-25861N9524JZanella Paul J · Ballston Spa, NYBuilt 1966 · S/N 28-3649N9524LHritz Michael G · Carlisle, PABuilt 1974 · S/N AA5-0524N95253Mmou LLC · Fort Worth, TXBuilt 1969 · S/N 28-25862N95255Herren Robert H · Lexington, KYBuilt 1969 · S/N 28-25863N95259Erickson Landon S · Fairbanks, AKBuilt 1969 · S/N 28-25866N9525JSandpiper Nag LLC · Louisville, KYBuilt 1966 · S/N 28-3650N95264Jorquez Andrew D · Santa Paula, CABuilt 1969 · S/N 28-25867N95265Red River Aviation Services LLC · Altus, OKS/N 28-25868N95266Walton Robert · Franklin Lakes, NJS/N 28-25869N9526BWildenberg Ronald · Beloit, WIBuilt 1981 · S/N 172RG0855N9526HAbove The Haze LLC · San Lorenzo, CABuilt 1975 · S/N 17266201N9526JWorthington Brian · Las Vegas, NVBuilt 1966 · S/N 28-3652N9526LAnderson Jeffrey · Ann Arbor, MIBuilt 1974 · S/N AA5-0526N9526WMarch Theodore M · Fernley, NVBuilt 1967 · S/N 28-22954N95270Get Away 1 LLC · St George, UTBuilt 1969 · S/N 28-25870N95271Ederer Martin J · Baraboo, WIBuilt 1969 · S/N 28-25871N9527JOklahoma Flight Academy LLC · Owasso, OKBuilt 1966 · S/N 28-3653N9527WDieck Michael J · Fayetteville, NCFirst renewal noticeS/N 28-22955N95285Bangerter James Alan · Indn Hbr Bch, FLBuilt 1969 · S/N 28-25875N9528DGreenhead Flight Services LLC · Bemidji, MNBuilt 1958 · S/N 22-6444N9528JGiles Dennis E II · Pearson, WIBuilt 1966 · S/N 28-3654N9529DHeil Jay E · Brownton, MNBuilt 1958 · S/N 22-6445N9529LMcdaniel Mark O · Martinsville, INBuilt 1974 · S/N AA5-0529N9529SRegistered aircraftBuilt 1965 · S/N 331N952JCCarver Jonathan E · Oxford, NCBuilt 2004 · S/N 5282N952MKhan Mohsin H · Lodi, CABuilt 1966 · S/N 3364N952SHNelson Chris · Crown Point, INBuilt 2005 · S/N 3920N952TBLong Jacob · Bend, ORBuilt 2011 · S/N 25074N95302Wright David W · Arlington, TXBuilt 1969 · S/N 28-25878N95303Morrison Robert F II · Denton, TXS/N 28-25879N95305Eagle Aviation Inc · Tucson, AZFirst renewal noticeBuilt 1969 · S/N 28-25880N9530BSierra Alpha Aeronautical LLC · San Antonio, TXBuilt 1981 · S/N 172RG0858N9530JNations Jeffrey L · Kingshill, VIS/N 28-3657N9530LClark Dale H · Discovery Bay, CABuilt 1974 · S/N AA5-0530N9530WGateway Flight Training LLC · Saint Louis, MOBuilt 1967 · S/N 28-22958
Back to AD 80-04-03 R2