OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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.

N6675LMcelhannon Fayette M Jr · Athens, GABuilt 1979 · S/N CE-882N6675QLoyal Aviation LLC · Loyal, WIBuilt 1973 · S/N 421B0442N6675VBrazier Glen A · Greenbush, MNBuilt 1967 · S/N 30033N6675YField Inspection LLC · Brawley, CABuilt 1980 · S/N TJ-254N6677BHess Chad · Boise, IDBuilt 1978 · S/N 21062816N6677LAeropacific Consulting LLC · Reno, NVBuilt 1979 · S/N TJ-209N6677RTre Aviation Corp · Wilmington, DES/N 21059654N6677VFandrich Abraham L · Clancy, MTS/N 30020N66784Grimm Phillip H · Draper, UTBuilt 1979 · S/N EA-34N6678C678c LLC · Pensacola Beach, FLBuilt 1979 · S/N TJ-235N6678SHawkeye Aero Sales LLC · West Des Moines, IABuilt 1976 · S/N CE-628N6678YNewhouse Eric · Corrales, NMBuilt 1983 · S/N EA-360N6679APegasus Specialty Leasing Inc · Paris, TXBuilt 1983 · S/N E-2082N6679XElite Aviation Group LLC · Pasco, WABuilt 1982 · S/N E-2041N6679YRanchlands LLC · Hyattville, WYBuilt 1988 · S/N E-2445N667CDCirrus Aircraft Shares Inc · Williamsburg, VABuilt 2005 · S/N 1301N667CWRegistered aircraftBuilt 2004 · S/N 1190N667DBGutierrez Jess R · Portland, ORBuilt 1977 · S/N CE-737N667PCMattie Joseph · Ester, AKBuilt 1984 · S/N 46-8508001N66801Cirrus Management LLC · Suwanee, GABuilt 1979 · S/N E-1603N6680BBush Douglas B · Santa Rosa Beach, FLBuilt 1978 · S/N 21062818N6680GHorst Commercial Ventures LLC · Sanger, TXBuilt 1979 · S/N TJ-236N66812Dehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1604N66818Schultz Gregory L · Greenbush, MNS/N D-10310N6681LRotary Industries Inc · Miami, FLBuilt 1979 · S/N TH-1088N6682ZDavis Brad L Trustee · Canton, MOBuilt 1979 · S/N E-1607N6683DRegional Consultants LLC · Wilmington, DEBuilt 1979 · S/N D-10311N6683NLn Skies LLC · Streetman, TXBuilt 1979 · S/N TJ-239N6683YGate Post Aviation LLC · Woodbury, CTBuilt 1979 · S/N TK-111N66840Lowery Aviation LLC · Burwell, NEBuilt 1983 · S/N E-2085N66844Munden Paul M · Amarillo, TXS/N EA-364N66849Hawk Aircraft Sales And Leasing LLC · Sterling Heights, MIBuilt 1979 · S/N TH-1092N6684DDowney Leasing LLC · Lexington, NEBuilt 1979 · S/N E-1610N6684VFba Leasing LLC · Mountain Brk, ALS/N TH-1089N6685RGlobal Distillation Services LLC · Reno, NVBuilt 1979 · S/N D-10314N6685VHeirborne LLC · Kansas City, MOS/N 30041N66863Taylor John Arthur · Mission Hills, KSBuilt 1983 · S/N E-2086N6686DN6686d LLC · Idaho Springs, COBuilt 1979 · S/N TH-1097N6686NClarity Aviation LLC · Anchorage, AKBuilt 1978 · S/N 21063146N6686VRegistered aircraftBuilt 1967 · S/N 30050N6686XCoughlin James G · Naples, FLBuilt 1979 · S/N E-1616N66876Mcmarlin Richard C · Santa Fe, NMBuilt 1979 · S/N D-10316N66878Cool Blue Air LLC · Wilmington, DEBuilt 1979 · S/N TH-1100N6687DVolare Flight Service LLC · Pine Village, INBuilt 1983 · S/N EA-365N6687VOsterberg Douglas L · Neenah, WIBuilt 1967 · S/N 30029N66885Turn Key Construction Services Inc · Lincoln, CAS/N EA-48N6688EHill Daniel DBA · Grove, OKBuilt 1979 · S/N D-10319N6688JQuesnel Robert Todd · Tomball, TXBuilt 1979 · S/N D-10299N6688NLedson Steven Noble · Sonoma, CAS/N 21063148N6688VBesch Marvin Eugene II · Redmond, WABuilt 1967 · S/N 30017
Back to AD 86-13-04 R3