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.

N6819WMikletich Christian E · Springfield, KYS/N 28-20957N6820BAnderas Per R · Green Bay, WIS/N 22-4116N6820LFoode Frank J · Cordova, AKBuilt 1974 · S/N 18-7409104N6820NLopez George P · Sacramento, CAS/N 680107N6821PComanche Logistics LLC · Lake City, FLBuilt 1960 · S/N 24-1954N6821URed Baron LLC · Middletown, DES/N 2536N6821VMiller Titan G · Tehachapi, CAS/N 20-0003N6822LDavis Robert E · Wasilla, AKBuilt 1974 · S/N 18-7409105N6822NBianchi Marion A · Goose Creek, SCBuilt 1968 · S/N 680116N6822WAjf Enterprises LLC · Des Moines, IAS/N 28-20960N6823HClay Howard C II · San Francisco, CAS/N 17265596N6823NTawil Anan · Salem, ORBuilt 1968 · S/N 680108N6823UClark Bradley K · Ypsilanti, MIBuilt 1963 · S/N 182N6823WThomas Kevin A · Selbyville, DEBuilt 1965 · S/N 28-20961N6824JMorrison Justin Gregory · Houston, TXBuilt 1976 · S/N 28-7625243N6824ULefevre Duane S · Grover, WYS/N 183N6824WRoberts John R Jr · Homestead, FLBuilt 1965 · S/N 28-20962N6825BAlborn Wyatt A · Homer, AKBuilt 1956 · S/N 22-4121N6825JByrd Mark L · Belpre, OHBuilt 1976 · S/N 28-7615368N6825NWilliams Jerry Riley Sr · Wabbaseka, ARS/N 680118N6825URipley Holdings Ltd · Santa Monica, CABuilt 1963 · S/N 184N6826NInterwest Management · Angwin, CABuilt 1968 · S/N 680109N6826WMartinak Charles J · Rehrersburg, PABuilt 1965 · S/N 28-20966N6827ULeong Thomas M · El Monte, CABuilt 1963 · S/N 186N6827VAerostar Air LLC · Kilgore, TXBuilt 1971 · S/N 20-0005N6827WShort Final Aviation LLC · Branson, MOBuilt 1965 · S/N 28-20967N6828BVantreese Jason B · Quanah, TXS/N 22-4125N6828NFisher Scott · Searcy, ARBuilt 1968 · S/N 680120N6828WOleary David L · Framingham, MABuilt 1965 · S/N 28-20968N6829NWilliams Mark J · Ojai, CAS/N 680110N6830EJackson Thomas M · Florissant, MOBuilt 1960 · S/N 56330N6830UJilek Dominic A · River Falls, WIBuilt 1963 · S/N 201N6831HQuarry Jon C · Memphis, TNBuilt 1975 · S/N 17265600N6831VMirage Partners LLC · Biddle, MTBuilt 1975 · S/N 20-1161N6832FJpf Ventures LLC · Owatonna, MNBuilt 1976 · S/N 28-7790165N6832PDrag Walter J · Longs, SCBuilt 1960 · S/N 24-1965N6832ULanetti Leonard J · Malvern, PAS/N 2537N6832VCrawford Sharri R · Rio Rancho, NMS/N 20-1162N6832WLitchfield Bobby Lee · Claremont, CAS/N 28-20973N6833BBlatchford Devin M · Arkansas City, KSBuilt 1956 · S/N 22-4131N6833CTexins Flying Club · Mckinney, TXBuilt 1965 · S/N 28-3024N6833FPatriot Aviation LLC · Huntington, INBuilt 1976 · S/N 28-7790166N6833JHumphries Aviation LLC · Maysville, KYBuilt 1976 · S/N 28-7625244N6834NSiebold David J · Painesville, OHBuilt 1968 · S/N 680124N6834UFlydog Aviation LLC · East Grand Forks, MNBuilt 1963 · S/N 2539N6834WFlores Lindenfelser Armando · Apache Junction, AZBuilt 1965 · S/N 28-20975N6835HIowa Lakes Community College · Estherville, IABuilt 1975 · S/N 17265602N6835JPronk Glen R · Crittenden, KYBuilt 1976 · S/N 28-7615371N6835NHirzel William J · Walbridge, OHBuilt 1968 · S/N 680112N6835UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 2540
Back to AD 80-04-03 R2