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.

N26454Camarda Edward W · Conroe, TXBuilt 1978 · S/N AA5A0598N26456Coleman Edward H · Tulare, CABuilt 1978 · S/N AA5A0600N2645QSigman Kenneth M · Birmingham, ALBuilt 1977 · S/N 28-7790411N26465Registered aircraftBuilt 1978 · S/N AA5A0612N26471N26471 LLC · Versailles, KYBuilt 1978 · S/N AA5A0615N26479N24679 LLC · North Royalton, OHBuilt 1978 · S/N AA5A0619N2647PTrinkle Aviation LLC · Kingsburg, CABuilt 1955 · S/N 22-2985N26498Dodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N 0836N2649PHoffmann Greg L · Centennial, COBuilt 1955 · S/N 22-2987N264ATAirline Transport Prof Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496088N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035N264CMVasquez Arthur D · Ocala, FLBuilt 1978 · S/N AA5A0588N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716N264DDSigman Aviation LLC · Pelion, SCBuilt 1997 · S/N 1098N264DMPersons Richard A · Arroyo Grande, CAFirst renewal noticeBuilt 1988 · S/N 264N264JSAllen James M · Gilmanton, NHBuilt 1993 · S/N 21522N264LWilder Paul D · Chattanooga, TNBuilt 2003 · S/N 23323N264MAShaffer John C · Talkeetna, AKBuilt 2004 · S/N 482-2004N264NDPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 28-42069N264SASundance Airport LLC · Yukon, OKBuilt 1968 · S/N 28-25258N26507Musgrave John R · Morris, ILS/N 1958N2650PGodlewski John A · Ormond Beach, FLS/N 22-2988N2651WStolworthy Spencer D · Maple Valley, WABuilt 1966 · S/N 3307N2651ZHelburg Michael L · Libby, MTS/N 1004-77N2652THart William · West Plains, MOBuilt 1971 · S/N 28-7205063N2652WRegistered aircraftBuilt 1966 · S/N 3308N2653PKoerner Stephen F · Kankakee, ILBuilt 1955 · S/N 22-2993N2654PSamson Mason H · Rives Junction, MIBuilt 1955 · S/N 22-2994N2656TCardinal Point Aviation Services LLC · Homestead, FLBuilt 1971 · S/N 28-7225079N2657MCurtis Christopher J · Wasilla, AKBuilt 1946 · S/N 12-970N2657WRegistered aircraftBuilt 1966 · S/N 3310N2658TLoer Stanley W · Grants Pass, ORBuilt 1971 · S/N 28-7205067N265AAWhitten Chris K · Alton, MOBuilt 1958 · S/N TD-132N265ACMorgan Nigel · Asheville, NCBuilt 1998 · S/N 407-98N265ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496098N265BHillestad Darrell · Aberdeen, SDS/N 25N265BSGrant Charles K · Topton, NCS/N 454N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081N265NDAri Ben Aviator Inc · Fort Pierce, FLS/N 2842065N26602Eastern New Mexico University - Roswell · Roswell, NMBuilt 1988 · S/N 0858N2660AN62689 Inc · Texarkana, TXBuilt 1952 · S/N 18-2184N2660PAnderson William B · Rogers, ARBuilt 1955 · S/N 22-3000N2660QSummit Aviation LLC · Spokane, WABuilt 1977 · S/N 28-7790413N26619Sides Michael E · Bartley, NEBuilt 1988 · S/N 0876N2661TSix One Tango LLC · Pismo Beach, CABuilt 1971 · S/N 28-7205069N2662TPlane Aviation LLC · Camarillo, CABuilt 1971 · S/N 28-7205070N2662WEaton Mark E · Houston, TXBuilt 1966 · S/N 3312N2663JN2663j LLC · Rehoboth Beach, DEBuilt 1988 · S/N 0877N2663PHoffrage Michael B · Fresno, CAS/N 22-3003N2664AZmuda Bruce V · Eagle River, AKBuilt 1952 · S/N 18-2179
Back to AD 80-04-03 R2