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.

N56918Virgil Osvaido J · Glendale, AZBuilt 1973 · S/N 28-7415037N5691PCoady Michael · Taylorville, ILBuilt 1959 · S/N 24-763N5692WFollmer Harvey C III · Trout Run, PABuilt 1963 · S/N 28-1045N5693QKaufman Ben · Liberty, UTBuilt 1965 · S/N 3045N56943Mcdowell David M · El Cajon, CABuilt 1973 · S/N 28-7425066N56947Wings Of Hope · Chesterfield, MOBuilt 1973 · S/N 28-7415027N5694HTischer William D · Shoreview, MNBuilt 1965 · S/N TD-243N5694UPlencner Robert E · Round Lake Beach, ILBuilt 1969 · S/N 28-26491N5694WLange James R · Tempe, AZBuilt 1963 · S/N 28-1060N56950Bodily Kent A · Washington, UTBuilt 1973 · S/N 28-7405038N56957Payne Glenn · Oregon, MOBuilt 1973 · S/N 28-7425070N56958Jackson Michael L · Nixa, MOFirst renewal noticeS/N 28-7425071N5695QBabb Douglas L · Telford, PABuilt 1965 · S/N 3046N5695W95whiskey LLC · Georgetown, MABuilt 1963 · S/N 28-1070N56964Lafollette Larry E · Strafford, MOBuilt 1973 · S/N 28-7405052N56966West David A · Astoria, ORBuilt 1973 · S/N 28-7425067N5696WGiglio Tom J · South Boston, VABuilt 1963 · S/N 28-1072N56970Simoneau Todd · Sandown, NHS/N 28-7405039N56976Tate Bird L Jr · Hammond, NYBuilt 1973 · S/N 28-7425075N56977Evans Holland L · Danielsville, GABuilt 1973 · S/N 28-7425076N56978Brindley James G · Collinsville, ALBuilt 1973 · S/N 28-7425077N5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271922N56986Loya Armando · Whittier, CABuilt 1973 · S/N 28-7425079N56987Ravotti Air LLC · Leechburg, PABuilt 1973 · S/N 28-7415032N56988Hillerman Paul J · Vinita, OKBuilt 1973 · S/N 28-7415033N56989Kenny Zachary D · Herndon, VABuilt 1973 · S/N 28-7405040N5698UNorby David S · Gooding, IDS/N 28-26495N5698WBurkett Aviation LLC · Hampstead, NCBuilt 1963 · S/N 28-1094N569932c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 28-7410040N56996Zarn Douglas J · Amboy, MNBuilt 1973 · S/N 28-7425080N56997Bibb John G · Paragould, ARBuilt 1973 · S/N 28-7425081N569FLN7396w LLC · Coeymans Hollow, NYS/N 28-7125413N569MKindred Daniel P · Jacksonville, ILFirst renewal noticeS/N 20-0009N569RVRicketts Michael D · Weirsdale, FLBuilt 2010 · S/N 91519N569WHGp Cub Air LLC · Sioux Rapids, IABuilt 1965 · S/N 18-8271N56AMPeavy Michael J · Chico, CABuilt 1976 · S/N 957N56BVEuroaviation Inc Trustee · KematenBuilt 1978 · S/N AA5A0719N56CPBulldog Aviation LLC · Goodyear, AZBuilt 1969 · S/N 700003N56DBBerger Dale · Bay Village, OHBuilt 2002 · S/N 1128N56DDMeier Perry S · Conroe, TXBuilt 1976 · S/N D2DN56DFThorpe Arthur N Jr · Salisbury, MDBuilt 1980 · S/N 44-8107030N56DGEagle East Aviation Inc · North Andover, MABuilt 1976 · S/N 17266239N56DWReed John S · Wasilla, AKS/N 18-7709159N56ECBpc Aviation LLC · Rosamond, CABuilt 1962 · S/N 17249661N56EPSanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17270728N56ERGsell Bruce Ward · Southampton, NJBuilt 1979 · S/N AA5B-1094N56FAir Kings LLC · West Chester, PABuilt 1975 · S/N 17265348N56FASilver Express Co DBA · Miami, FLBuilt 1978 · S/N 172-69682N56FDDefibaugh Fred M · Chino Alley, AZS/N 3535N56GBCalhoun Keith A · Springville, TNBuilt 1997 · S/N 56
Back to AD 80-04-03 R2