OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,498

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N17568Chance Research Corp · Mineral Wells, TXBuilt 1977 · S/N D-9984N1756RMontana Rose 185 LLC · Cornwall, VTBuilt 1974 · S/N 18502476N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739N1756WIverson Bradley · Grinnell, IABuilt 1972 · S/N D-9409N17571De Oliveira Derek · Meadow Vista, CABuilt 1977 · S/N E-983N17577James Rodney D · Bono, ARBuilt 1977 · S/N TE-1091N1757GMatrix Aviation Inc · Ponte Vedra Beach, FLBuilt 1962 · S/N TC-350N1758UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 20700358N1758WJanneck Curtis · Mooresville, INBuilt 1972 · S/N CE-411N175LKern Charter Service Inc · Bakersfield, CABuilt 1977 · S/N E-985N175SPN500aa LLC · Wilmington, DES/N 414A0313N175TPadgett Don K · Albuquerque, NMBuilt 1971 · S/N D-9259N175USAtlas Property Management LLC · Broken Arrow, OKS/N 0570N17604Montgomery Aviation Corp · Montgomery, ALBuilt 1977 · S/N TE-1094N17639Peterson Eric S · San Jose, CABuilt 1977 · S/N E-997N1763W63 Whiskey LLC · Seattle, WABuilt 1973 · S/N E-406N1763XRobins Nest Aviation LLC · Harrison, OHBuilt 1975 · S/N 21060784N1764XLeschber Larry · Hutto, TXBuilt 1975 · S/N 21060785N17650Pynes Anthony P · Round Rock, TXBuilt 1977 · S/N D-9993N17656Liddell Patrick A · Columbia Falls, MTBuilt 1977 · S/N D-9995N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810N17668Broadway Travis A · Alexandria, LABuilt 1977 · S/N E-1001N17669Srg Enterprises LLC · Montgomery, ALBuilt 1977 · S/N E-1002N1767RHamel David A · Klamath Falls, ORBuilt 1974 · S/N 18502487N1768ERoyal Air Freight Inc · Waterford, MIBuilt 1978 · S/N 310R1566N17692Starnes Robert D · Suwanee, GAS/N CE-700N17698Spindel Stuart H · Hawesville, KYBuilt 1977 · S/N E-1005N1769RCt Aviation LLC · Waverly, NEBuilt 1974 · S/N 18502489N176LFFour Basics LLC · Olathe, KSBuilt 1977 · S/N E-1052N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710N176RKY-12 Investments LLC · Alexandria, VABuilt 2020 · S/N TH-2532N176STCp A36 Inc · Knoxville, TNBuilt 1976 · S/N E-884N176TCRedtail Cirrus LLC · Boise, IDBuilt 1979 · S/N 18503814N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926N176WHarwell Evin Dtrustee · Howell, MIBuilt 1978 · S/N E-1335N176XClub Turbo 176 LLC · Santa Clara, CABuilt 1976 · S/N E868N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383N17702Bosley Blake R · Richmond, TXBuilt 1977 · S/N CE-701N17703Dakota Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N E-1007N1770RRegistered aircraftBuilt 1974 · S/N 18502490N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998N1772WRichland Flight Academy LLC · Sidney, MTBuilt 1972 · S/N E-377N17732Wright Brian L · Franklin, TNBuilt 1977 · S/N TE-1102N17735Stoppelbein Colby · Kenansville, NCBuilt 1977 · S/N CE-703N17738Lambert Michael C · San Jose, CABuilt 1977 · S/N CE-702N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003N17747Davis 180 LLC · Baton Rouge, LABuilt 1977 · S/N CE-704
Back to AD 86-13-04 R3