OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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.

N8245DBrozenske Donald A Trustee · Wenham, MABuilt 1991 · S/N CE-1570N8245JSln Aviation LLC · Salina, KSBuilt 1991 · S/N E-2650N8245RPella Michael J · Fargo, NDS/N 30452N8246VCaliber Construction Inc · Columbia, KYBuilt 1991 · S/N CE-1620N8247AQuality Kiln & Dryer Inc · Oakdale, LABuilt 1991 · S/N CE-1625N8248BSmith Kirk A · Searcy, ARBuilt 1991 · S/N TH-1633N8248KPlane Haven LLC · Kalispell, MTBuilt 1991 · S/N E-2678N8249MRancho Bonito LLC · Oxnard, CABuilt 1977 · S/N 21062039N824BCAonvo Investment LLC · North Miami, FLBuilt 1977 · S/N 340A0306N824HJC & W Aviation LLC · Birmingham, ALBuilt 2003 · S/N 0602N824MAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N P21000763N824MRTspy Services Inc · Wilmington, DEBuilt 2004 · S/N 1152N824PCapital Premium Finance · Tallahassee, FLS/N 1206N824PFWashington Square Cirrus LLC · Sagaponack, NYBuilt 2003 · S/N 0504N824RBShark Water Systems LLC · Hobbs, NMBuilt 1979 · S/N 414A0411N82500Snider Douglas H · Seguin, TXS/N ES-082N8250RM O S T Express · Franklin, TNS/N CE-1734N8252MApplied Olap Inc · Huntsville, ALBuilt 1969 · S/N 21059252N8252TRegistered aircraftBuilt 1990 · S/N CE-1545N8253CAl Stevens Construction LLC · Overland Park, KSBuilt 1990 · S/N CE-1546N8253MHudak Organization LLC · Cedar Grove, NJBuilt 1969 · S/N 21059253N8253NTejas Aviation Services LLC · Wilmington, DEBuilt 1993 · S/N CE-1743N8253QTogo Aviation Services LLC · Palmer, AKBuilt 1976 · S/N U20603249N8253RSalem Virgil J · Cimarron, KSBuilt 1972 · S/N 30440N8255ESouth Road Partners Inc · Kentfield, CABuilt 1991 · S/N CE-1630N8255QKavik Aviation Services LLC · Palmer, AKBuilt 1975 · S/N U20603116N8256HGj Flight Group LLC · Newark, DEBuilt 1991 · S/N E-2664N8256QRegistered aircraftBuilt 1975 · S/N U20603117N8257HS And G Ventures LLC · Wilmington, DEBuilt 1992 · S/N TH-1650N8257RPreiss Michael C · Southaven, MSBuilt 1972 · S/N 30450N8259AParisien Robert · Bow, NHS/N EA-529N8259CShepard Christopher N · Westerville, OHS/N CE-1763N8259EAtlanta Human Performance Center Inc · Mableton, GABuilt 1992 · S/N CE-1641N8259LFriendly Air LLC · Tampa, FLBuilt 1992 · S/N CE-1642N825CD825cd LLC · Camarillo, CABuilt 2002 · S/N 0189N825ECPeterson Air LLC · Chisago City, MNBuilt 1999 · S/N E-3272N825EGFlying Eagle LLC · Wilmington, DEBuilt 1976 · S/N CE-668N825FWRegistered aircraftBuilt 2005 · S/N 1368N825GBMassari Stephen · Somerville, NJBuilt 2009 · S/N E-3893N825TGDodenhoff Robert M · Middletown, CTBuilt 2002 · S/N 0328N825VGarmin At Inc · Salem, ORBuilt 1977 · S/N E-963N8261K8th Street Aviation LLC · Urbandale, IABuilt 1992 · S/N E-2690N8261MZaller Anthony J · Phoenix, AZBuilt 1970 · S/N 21059261N8261VTds Airpro LLC · Shreveport, LABuilt 1992 · S/N E-2691N8262DMistarz Bruce E · Gainesville, GABuilt 1992 · S/N CE-1645N8262MThrasher Dennis L · Tucson, AZBuilt 1970 · S/N 21059262N8262RReder Scott W · Fruitdale, SDBuilt 1972 · S/N 30442N8263ASullivan Larry R · Tranquillity, CABuilt 1993 · S/N CE-1730N8263GFitzpatrick Dennis B · Mccall, IDBuilt 1977 · S/N U20603784N8263VPrecision Service Mtr Inc · Addison, ILBuilt 1990 · S/N EA-504
Back to AD 86-13-04 R3