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.

N56GTDonaldson Timothy A · Oklahoma City, OKBuilt 1976 · S/N AA5B-0344N56HCFaire Ken · Mojave Valley, AZBuilt 1976 · S/N 2N56HJRobinson Douglas J · Dayton, NVBuilt 1997 · S/N 24348N56HYCipolli Robert J · Montgomery, MABuilt 2003 · S/N 2222N56JUSurfield Ronald W · Leonardtown, MDS/N 22159N56KCCrawford William K · Ovilla, TXBuilt 2004 · S/N T018N56LBArlington Flight Services Inc · Arlington, WABuilt 1959 · S/N TD-279N56LJL & J Aviation Inc · Atwater, CABuilt 1979 · S/N 17272751N56MWHeartland Ag Aviation LLC · Lancaster, KSBuilt 1975 · S/N 17265314N56NAHampden Aviation Services Inc · Northampton, MABuilt 1979 · S/N 28-8016073N56PPGray Charles C · Westmont, ILBuilt 1996 · S/N 20478N56RPPeplinski Robert E · Sullivan, WIBuilt 2004 · S/N 865N56RVLudtke Frederick · Freeland, WAS/N 20005N56RWFilice Mario · Minden, NVBuilt 1980 · S/N 555N56SCHighley Robert W III · Aldie, VABuilt 1975 · S/N AA5-0754N56SELuts Phillip · Escondido, CABuilt 1999 · S/N 24682N56SJShaw Kenneth F · Redding, CABuilt 1999 · S/N 1267-99N56WACarter Cameron T · Buffalo, NYBuilt 1983 · S/N 603N56WBTmr Aviation LLC · Fredericksburg, VAS/N 28-4470N56YYSale Reported · Centerville, UTSale reported, pending cancellationBuilt 1972 · S/N 69-1N57006Olsen Chad · Hendricks, MNBuilt 1973 · S/N 28-7415034N5700ERegistration Pending · Fort Lauderdale, FLRegistration pendingBuilt 1978 · S/N 17271923N5700FTubbs Arthur R · Audubon, NJBuilt 1968 · S/N 28-24849N5700PEdmundson George · Burlington, WABuilt 1959 · S/N 24-773N5700WViriyaphap Chattada · Birmingham, ALBuilt 1963 · S/N 28-1104N5701FKaspar Roger · Aurora, ILBuilt 1968 · S/N 28-24885N5701USouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1969 · S/N 28-26498N57020Kerschner Ira Henry · Cochranville, PABuilt 1973 · S/N 28-7425083N5702FKoza William J · Albert Lea, MNBuilt 1968 · S/N 28-24881N5702QBailey Jacob Kyle · Rosharon, TXBuilt 1965 · S/N 3053N5703UXcelleration Aviation Inc · Sarasota, FLBuilt 1969 · S/N 28-26500N5703WKelley Keith B · Forney, TXBuilt 1963 · S/N 28-1128N5704FJames Alfred F · Katy, TXBuilt 1968 · S/N 28-25015N5704UZephyr Air LLC · Hickory, NCS/N 28-26501N5705DBirdwell Brett M · Lewistown, MTBuilt 1956 · S/N 22-4401N5705FWilkinson David E · Waleska, GABuilt 1968 · S/N 28-25016N5705WSmart Avionics Inc · Marietta, PABuilt 1963 · S/N 28-1115N5706DReese Lonnie E · Talking Rock, GAS/N 22-4402N5706PAldredge J Ralph · Milner, GABuilt 1959 · S/N 24-779N5706QKnox James · Perryton, TXBuilt 1965 · S/N 3055N5706USaccento Anthony J · Binghamton, NYBuilt 1969 · S/N 28-26503N5706WShick Andrew C · Grand Junction, COS/N 28-1165N5707FEure Michael T · Moyock, NCBuilt 1968 · S/N 28-24833N5708QLowry Gregory A · Beaufort, SCBuilt 1965 · S/N 3056N5708UFwj Aviation LLC · Crown Point, INBuilt 1969 · S/N 28-26506N5709FBitterfield Colin · Las Vegas, NVS/N 28-25019N5709UGundersen Lance · Murfreesboro, TNBuilt 1969 · S/N 28-26507N5709WBrinkley Ralph L · Lexington, NCBuilt 1963 · S/N 28-1169N570MATuminello Joseph A · San Francisco, CABuilt 2005 · S/N 496-2005N5710FOso Air LLC · Missoula, MTBuilt 1968 · S/N 28-25020
Back to AD 80-04-03 R2