OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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.

N3585Coon Donald N · Shedd, ORBuilt 2003 · S/N 25365N3585QLerner Daniel A · East Durham, NYBuilt 1973 · S/N 17261685N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687N3587XFlynn Sean C · Torrance, CABuilt 1968 · S/N 680156N3588PLewis' Flying & Maintenance Svc Inc · Morse, LABuilt 1955 · S/N 18-4543N3589Sale Reported · Lonoke, ARSale reported, pending cancellationBuilt 1970 · S/N 680N3589KClark Joseph D · Kilgore, TXBuilt 1967 · S/N 28-23646N3589PNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1955 · S/N 18-4544N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115N358MMatuska Douglas G · Kent, WABuilt 1999 · S/N 20913N358RWHawley Elizabeth B · Wichita Falls, TXBuilt 1979 · S/N AA5B1066N358WGenco Holdings LLC Series A · Corpus Christi, TXBuilt 1966 · S/N 3417N3590PSoyars Thomas E · San Marcos, TXBuilt 1955 · S/N 18-4545N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225N3591RAwmr LLC · Conroe, TXBuilt 1970 · S/N 28-5704N3592KBeckler Benjamin C · Middle Granville, NYBuilt 1967 · S/N 28-23647N3592PDengler Steven G · Lopez Island, WABuilt 1955 · S/N 18-4550N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692N3592RBurnt Ridge LLC · Kalispell, MTBuilt 1969 · S/N 28-5705N3592XBryant David Wayne · Ada, OKBuilt 1968 · S/N 680161N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694N3595PSchumacher Craig A · Fairbanks, AKBuilt 1955 · S/N 18-4553N3595ZJohnson Issac · Krugerville, TXBuilt 1960 · S/N 18-7388N3596KStall Breakers LLC · Sachse, TXBuilt 1967 · S/N 28-23648N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601N3597KQuinn Knives LLC · Julian, CABuilt 1967 · S/N 28-23649N3597PBickford Tierra L · Big Lake, AKBuilt 1955 · S/N 18-4555N3599HSitter Duane A · Hayward, CABuilt 1977 · S/N 20-1238N3599ZBell Mark W · Soldotna, AKS/N 18-7393N359ALTyson Aviation LLC · Sherrills Ford, NCBuilt 1973 · S/N 17262020N359HEiden Ryan J · Central, AKBuilt 2024 · S/N JA2102155N359MAZig Zag LLC · Madison, ALBuilt 2000 · S/N 2069N359RVVik Douglas L · Payson, AZBuilt 2001 · S/N 23960N359TCMartin Robert · Amory, MSBuilt 2011 · S/N 11412N35AKPiatt Christopher M · Wasilla, AKS/N 1001N35AMJoseph Thomas C · Raleigh, NCS/N 28-5490N35ATLoomis Matthew · Oshkosh, NEBuilt 1973 · S/N 28-7305530N35CKColeman Tyler R · Sierra Vista, AZBuilt 1993 · S/N 20165N35DTTeufel Armin U · Phelan, CAFirst renewal noticeBuilt 1998 · S/N 321N35FBEwins John H · Danville, CABuilt 1969 · S/N JMKB-1N35KKearns Jeff C · Carrier Mills, ILBuilt 1995 · S/N 20482N35KCBuchanan Tevah · St George, UTBuilt 1996 · S/N 3-608N35LBWebb John M · Chugiak, AKBuilt 1973 · S/N 1N35PHTsi Holdco Inc · Virginia Beach, VABuilt 1984 · S/N 1981-AN35RSSudderth Robert W · Holly Lake Ranch, TXBuilt 1994 · S/N 1785LN35TXBauries Brian W · Abilene, TXBuilt 1994 · S/N 19020C
Back to AD 80-04-03 R2