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.

N16320Basurto Kathryn A · Sacramento, CABuilt 1973 · S/N 28-7305225N1632EXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 17271074N1632HM & B Aero LLC · York, PABuilt 1977 · S/N 28-7790319N1632JDavid A Bowden · Duncan, OKBuilt 1968 · S/N 28-24019N1632PWilley Larry E · Fremont, OHBuilt 1954 · S/N 22-2446N16340Schwartz Gregg M · Ambler, PABuilt 1973 · S/N 28-7325245N16341Schmitz Frederick · Atlanta, GAS/N 28-7325246N16343Starlight Real Estate Investments Inc · Punta Gorda, FLS/N 115N16348Mcelyea Shawn T · Aledo, TXBuilt 1973 · S/N 28-7325249N1634JLemaire Norman J Jr · Taunton, MABuilt 1968 · S/N 28-24021N16350Dunn Mitchell R · Hayden, ALS/N 28-7305229N16351Degraaff Norman L · Friday Harbor, WABuilt 1973 · S/N 28-7305231N16357Ktup Aviation LLC · Belden, MSBuilt 1973 · S/N 28-7325253N16359Skinner Colin L · Hartland, VTBuilt 1973 · S/N 28-7305233N1635JDalsco Inc · Dover, DES/N 28-24820N1635PRegistered aircraftN-number assigned, not yet registeredS/N 82384N16365Harding Keith A · Newport News, VABuilt 1973 · S/N 28-7325255N16367Swartzbacker Paul · New Lenox, ILBuilt 1973 · S/N 28-7305237N16374Milliard Craig R · Benicia, CABuilt 1973 · S/N 28-7305238N1637EJag Flying Club Inc · Morgantown, WVBuilt 1978 · S/N 17271077N1637GLejeune Robert S · Basile, LABuilt 1968 · S/N 113N16382Reick Gregg G · Minnesota City, MNBuilt 1973 · S/N 28-7325259N16385Haines Michael C · Wadsworth, OHBuilt 1973 · S/N 28-7305242N1638JSmith Bryan Alexander · Cabot, ARBuilt 1967 · S/N 28-24026N16393Parker Owen · Collyer, KSBuilt 1973 · S/N 28-7325264N16398Withers Harry R · Beaufort, SCBuilt 1973 · S/N 28-7305244N1639GGhostwriter Airshows LLC · Hustonville, KYBuilt 1968 · S/N 115N1639JAll American Aviation Services Inc · Fayetteville, NCBuilt 1967 · S/N 28-24027N163AMRogers Brian D · Pacific, MOBuilt 1968 · S/N 28-5009N163BCClear Skies Aviation Inc · Hayward, CABuilt 2004 · S/N 1370-2004N163CMRegistered aircraftBuilt 2010 · S/N 22787N163GCBartholomew Terry L · Pavilion, NYBuilt 1973 · S/N M-1469N163MABlue Dawg LLC · Sandpoint, IDBuilt 2005 · S/N 2303N163SRRegistration Pending · Helena, MTRegistration pendingBuilt 1989 · S/N 163N16402Peters Dale M · Naknek, AKBuilt 1973 · S/N 28-7305245N16409Pridmore Joshua B · Lubbock, TXBuilt 1973 · S/N 28-7325265N1640EBanan Abdolreza · San Diego, CABuilt 1978 · S/N 17271078N1640GTownsend Gary V · Sunderland, VTS/N 116N16410Cherokee Five LLC · Bakersfield, CABuilt 1973 · S/N 28-7325266N16412Cherokee N16412 LLC · Peoria, AZBuilt 1973 · S/N 28-7305247N16417Riddle Christopher Joseph · Auburn, CABuilt 1973 · S/N 28-7305249N16418Hallgren Mitchel T · Sycamore, ILBuilt 1973 · S/N 28-7305250N16425Box Aviation Inc · Montgomery, ALBuilt 1973 · S/N 28-7305251N1642PBangerter Timothy W · Leoti, KSBuilt 1954 · S/N 22-2458N16430Lyons Larry A · Stockton, ILBuilt 1973 · S/N 28-7305252N16433Pn4 Aviation Holdings LLC · Bishop, CABuilt 1973 · S/N 28-7325271N16434Livingston Charles · Franklinville, NYS/N 28-7325273N16435Gumms Leroy J · Perris, CAS/N 28-7305254N1643JDe Bry Daniel G · Dowagiac, MIS/N 28-24034N1643PPacer Air LLC · Wilmington, OHBuilt 1954 · S/N 22-2459
Back to AD 80-04-03 R2