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.

N6530JSalmon Woody W · Chalkyitsik, AKBuilt 1968 · S/N 28-4969N6530RByers Travis M · Villa Rica, GABuilt 1979 · S/N 172RG0199N6530UHeidelberg Haley · Huntington, TXBuilt 1962 · S/N 2313N6531CDorr Juergen W · Mundelein, ILBuilt 1978 · S/N 28-7890380N6531RBruno Gennaro S · Lewes, DEBuilt 1979 · S/N 172RG0200N6532CQuartarolo Pete · Santa Rosa, CABuilt 1978 · S/N 28-7890381N6532FCouch Walter Jack · Patterson, LAS/N 17273234N6532JGarner Aviation LLC · Tampa, FLS/N 17273885N65339Shaw Andrew G · Huntingdon, PABuilt 1999 · S/N 565N6533JPaulson James L · Lawrenceville, NJBuilt 1968 · S/N 28-4973N6533LNorthcutt Cecil W III · Ponder, TXBuilt 1974 · S/N AA5-0633N6533W21 Luna LLC · Phoenix, AZBuilt 1965 · S/N 28-20612N6534BMurphy Timothy · Lake City, FLS/N 1203N6534UHuertas Andrew · Van Nuys, CAS/N 2317N6535GBbjs Investments LLC · Burlington, WIBuilt 1979 · S/N 17273606N6535TDobson Richard W · Phenix City, ALBuilt 1968 · S/N MB-360N6536JCooper David M · Sedona, AZS/N 28-4977N6536VTran Dai A · Rancho Cucamonga, CABuilt 1980 · S/N 172RG0760N6536WDenny David F · Bath, NCS/N 28-20615N6537DCunningham Edward A · Washington, DCBuilt 1979 · S/N 17272853N6537FWheels Up Aviation LLC · Pittsburgh, PABuilt 1979 · S/N 17273236N6537HRivers Robert A · Oxford, NCBuilt 1975 · S/N 17265480N6537JTimer Anna Mae · Wildwood Crest, NJBuilt 1968 · S/N 28-4978N6538FMbk Leasing And Consulting LLC · Lakeland, FLBuilt 1979 · S/N 17273237N6538JBerra Robert J · Burtonsville, MDS/N 28-4980N6538RFunnell John R · Cedar Park, TXBuilt 1974 · S/N MB-712N6538VSommer Timothy T · Combined Locks, WIBuilt 1980 · S/N 172RG0762N6539HAbove The Haze LLC · San Lorenzo, CAS/N 17265481N6539RSpencer Alexander Joshua · North Las Vegas, NVS/N MB-713N6539WYounglove Donald L · Mendota, ILBuilt 1965 · S/N 28-20618N653BQQuilty Stephen M · Abingdon, VABuilt 1968 · S/N 28-5055N653QPhillips Robert B · Coshocton, OHBuilt 1959 · S/N TD-201N653SHGivens Tyler · La Vernia, TXBuilt 2003 · S/N 3504N653SRVertex Aviation Services LLC · Burlington, WABuilt 1968 · S/N 17701048N653WChesebro Ben D · Oro Valley, AZBuilt 1998 · S/N 60053N6540WRiggs Charles A · Pembroke Pines, FLBuilt 1965 · S/N 28-21266N6541URegistered aircraftBuilt 1962 · S/N 2324N6542HOwens Flight Training LLC · Lafayette, LABuilt 1975 · S/N 17265482N6542VHarris Dakota · Goose Creek, SCBuilt 1980 · S/N 172RG0765N6542WBaird Philip D · Judith Gap, MTS/N 28-21268N6543DBatte Randall E · Forest, MSBuilt 1979 · S/N 17272855N6543UGiesey William · Philadelphia, PABuilt 1962 · S/N 2326N6543VChupito Sabrocito LLC · Paso Robles, CABuilt 1980 · S/N 172RG0766N6543WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-20622N6544KWaldron Ronald J · Strongsville, OHBuilt 1980 · S/N 17274209N6544TCourtney John T · Woodbridge, CTBuilt 1968 · S/N MB-365N6545DCosta Flying Service Inc · Painted Post, NYBuilt 1979 · S/N 17272856N6545GBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1971 · S/N 15072045N6545HAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265483N6545RBonilla-Cruz Carlos · Houston, TXBuilt 1974 · S/N M-1581
Back to AD 80-04-03 R2